I have a Single-Relational "Existing Supplier" field in the primary table, which link to the Multi-Relational field "Available Suppliers" in Suppliers auxiliary table. "Value display format" of Suppliers table is "{FirstName}, <b>{LastName}</b> - <b>{Code}</b>". The submit form shows 2 fields "New Supplier?" Binary/Trinary filed (with 2 options: New Supplier, Existing Supplier). and "Existing Supplier" field. How can I control "Existing Supplier" field based on "New Supplier?" field?
For example:
If "New Supplier?" is New Supplier
disable "Existing Supplier" field dropdown list
Else if "New Supplier?" is Existing Supplier
disable the icon next the dropdown list of "Existing Supplier" field. which link to adding new record form
Thank you