# Having Issue Using Join Table

**URL:** https://www.five.org/t/having-issue-using-join-table/419
**Category:** How do I?
**Created:** [May 6, 2024, 8:26pm UTC](https://www.five.org/t/having-issue-using-join-table/419 "2024-05-06T20:26:12Z")
**Posts on this page:** 3
**Page:** 1

<div class="post-metadata">

### Author: ![RMittelman](https://yyz2.discourse-cdn.com/flex030/user_avatar/www.five.org/rmittelman/32/447_2.png) [@RMittelman](https://www.five.org/u/RMittelman)
#### Post date: [May 6, 2024, 8:26pm UTC](https://www.five.org/t/having-issue-using-join-table/419/1 "2024-05-06T20:26:12Z")

</div>

I am trying to have a many-to-many relationship using a join table. The purpose is when setting up a report I can identify which Study Groups should get that report by default.

I’ve added the **ReportGroups** join table containing fields for the ReportKey and StudyGroupKey among others. I added a form for this table, and added a new page to the SetupReports form for a list of Study Groups. So far so good.

But something is going wrong in the application. When I pick the report and go to the Study Groups page and try to add a group, nothing appears in the drop-down list of Study Groups. I’ve had this issue before. I know I’m missing something simple. What’s missing that I can’t add a group to the report?

[BrandeisConejo-20240506-2019340805296.fdf](https://www.five.org/uploads/short-url/3TVD7iubChWHuNL6IzPxdKxs26L.fdf) (4.5 MB)

---

<div class="post-metadata">

### Author: ![Jo-Anne](https://yyz2.discourse-cdn.com/flex030/user_avatar/www.five.org/jo-anne/32/45_2.png) [@Jo-Anne](https://www.five.org/u/Jo-Anne)
#### Post date: [May 8, 2024, 9:18pm UTC](https://www.five.org/t/having-issue-using-join-table/419/2 "2024-05-08T21:18:07Z")

</div>

Hi Ron,

For your Study Group Key field on your Report Groups form, you don’t have a referenced form, you need to add StudyGroups here and then your lookup will work.

 ![image](https://canada1.discourse-cdn.com/flex030/uploads/five/original/1X/1668923659652591d25efe971c71e09f75f7611d.png)

---

<div class="post-metadata">

### Author: ![RMittelman](https://yyz2.discourse-cdn.com/flex030/user_avatar/www.five.org/rmittelman/32/447_2.png) [@RMittelman](https://www.five.org/u/RMittelman)
#### Post date: [May 9, 2024, 2:31am UTC](https://www.five.org/t/having-issue-using-join-table/419/3 "2024-05-09T02:31:47Z")

</div>

Thanks Jo-Anne! I figured that out also.
