Portal field problem
I'm running FMPA 14.0.1. I have a portal that is displaying fields from two separate tables. I recently succeeded in creating complicated conditional value lists based on distantly related tables and fields. I have one final issue that has just come up: The third field is now autofilling its results in the first record to all the records in the portal. I do not know how to troubleshoot this. I don't think the relationship is the issue, but I am including that info below, as well as a screenshot of what I am talking about. The three value lists are dependent on each other, so the "Chemicals" value shouldn't be available for items 2-4.
Any thoughts on how to troubleshoot this?
Thanks for any help,