Additional Information for the request above. I am adding a screen shot of the layout so the issue is more apparent. I want to be able to say if the portal row showing on the layout is empty, then do not show the record.
You will see on the screenshot that I have filtered the portal to show me only the positions of one client. I want to send the client the layout with only their topics that they are following on it and not the topics that would relate to another client.
I hope this helps clarify the problem somewhat. Unfortunaltey I am not as knowledgeable about Filemaker functions as I would like to be.
Found the answer:
Set Variable $ClientName; Value: gClientNameFilter
Enter Find Mode
Set Field[fkClientID; $ClientName]
Help! This portal stopped filtering. Everything was working fine when I tested this. The portal was filtering properly but then when I loaded the database on Filemaker server and added real data to the databse the portal stopped filtering properly. I have a script set as above and a filter portal criteria of $ClientName=fkClientID. The search works and finds all the records that are related to the proper client but it does not display all of the information in the portals. For instance, if I am showing the portals in a list layout with the data will show in the portals on the first two records, but will not show up on any subsequent records. Also, it will not show the client that we are searching for in the top of the portal when it does show the data. I am not sure what went wrong, but I can't seem to find my way back to what was working before.