Auto select a conditional(filtered) dropdown based on selection of another dropdown
A user has to select the company to do business with from a dropdown (related Hauler table). The Contact table is related to the Hauler table. The Contact table has multiple contact information i.e. ...
It is a two part solution. Build a conditional against the Related Contact so that only Contacts for the Company can be selected.
The second part is to build a Record Picker report where you filter Contacts to show Related Contract Type = XX where XX is the value for the Dispatch. Then specify on the form that "Record Picker Dispatch" or whatever you call it is to be used.
Here is a screen shot of setting the report in a form.
z
You might think about expanding the logic in Record Picker for example Contact Status = Active. This way as Contacts come and go from the Company, your report is dynamically correct.
------------------------------ Don Larson Paasporter Westlake OH ------------------------------
