Portal relationship showing all records
File Maker Pro 10 pc issue. I have created this relationship: faculty table guidence committee member field = students table name ID field ~= students table2 guidence committee field = nress faculty table2 fullname field. The portal is reporting all student name IDs. I want the portal to report only student name IDs that match the faculty full name in the guidence committee field. Any suggestions?
I can't figure out what relationship you have here
Sounds like it should be:
Faculty::MemberID = Students::MemberID
In which case, a portal to students on the Faculty table will list only the records in Students with a matching member ID.