Filtered lists from related records

Discussion created by crmorris2 on Feb 24, 2017
Latest reply on Mar 1, 2017 by crmorris2

Hi all,


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.


Help, please!



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.

Portal test.png



Thanks in advance!