I have a table of Sites. Each site has many contracts.
Flash forward to a table of Projects. On my project I want to select a contract, and I want the sites to be shown conditionally, so that the site shown includes the contract selected (so typically, the conditional drop the 2 fields must equal each other).
Example:
Site A is associated with Contract 1 and Contract 2 (children).
Site B is associated with Contract 1 (child).
On the project, select Contract 2. In the Site dropdown, only Site A is shown.
------------------------------
Mike Tamoush
------------------------------
