Good afternoon everyone,
I hope your day is going well. Thanks in advance for any assistance you can provide! I'm going to attempt to keep the description of my issue succinct, but I can't make any promises...here we go...
As part of a solution I'm developing, I have three related tables. For simplicity sake let's just call them table A, B, and C (I'll be referring to the table occurrences and corresponding portals by the same names). The following bullet list describes my design:
- T.O. A has a one-to-many relationship with T.O. B, and T.O. B has a one-to-many relationship with T.O. C.
- I've created a "Main" layout associated with Table A
- I have placed two portals on the "Main" layout: one portal displaying records from T.O. B, and a second portal displaying records from T.O. C
- When the desired record from T.O. A is selected the expected records are displayed in the portal B
- I've created a script which, when trigger by a user selecting a field in portal B, sets the value of a global field in Table A to the value of the of the primary key of the selected record.
- I created a second T.O. of Table C with a foreign key field which stores the the value of the primary key field of the record selected in portal B and related it to the global field found in T.O. A
I expected the results of this configuration to allow the user to make the following two selections, ending with a single related record being displayed in portal C:
Selection 1 - select a record from T.O. A
Selection 2 - select a record from the resulting found set displayed via portal B
What portal C actually displays is all the records related to the user selection from T.O. A
My brain hurts and I need help. Once again, thanks in advance for taking the time to respond. Have a great day!