crmorris2

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)

tables.png

 

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)

list.png

 

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!

 

Craig

Outcomes