I am quite new to filemaker but I am getting the hang of it, slowly.
I have 2 tables and they are related by a user id. What I want to do is get a list of records with a mix of fields from both tables.
I have no problem with getting the list, what I am having trouble with is filtering this list. I have tried creating a portal but it doesnt seem to work and only shows 1 record on the list but I can actually click through the records.
I have attached a few screenshots and hope it makes sense.
My tables: (ODBC Source with many more tables but these are the only ones I need data from)
My list which I open with a script to only show records from a certain course (not finished the formatting of the layout as you can see)
Testing a portal on another layout. As you can see it has the records but only gives me one record in the list.
Thanks in advance!