The pick list from [custom table] ( aka cascade drop down) control will bring forward a window to select select an record from a custom table and copy multiple values into multiple fields from the that table to the current custom table.

This control is much like a cascading pick list where each subsequent field filters down the next field. For instance; you need three drop downs such as make, model and version. First you need to create a custom table to store the values. These values will be stored in fields named make model and version. Using the interface of the 'Automobiles' table you can either import or data-enter your values such as VW, Fords, Chevy and so forth.

To import records into the master list, the best way would be to use the single import.  You can find more information here.

This control will replace multiple field values with the value from the drop down list. If you want to replace just a single fields  please see the Drop Down Lookup

To use this control follow these steps.
1) Open the form in the forms designer

2) Click the "Buttons" button in the toolbar

3) Drag the "Picklits from xxxxx" controls onto the form. (Where xxxxx is the custom table to want to use as the pick list data source)

 

 4) This Edit Linked Fields form will automatically pop open. You need to use the drop downs to match the fields from the pick list table ( source) into your fields in the custom table you are currently editing ( destination)

To setup the control you need to set the fields that are copied in the properties




You can set the text on the button by changing the Button text Property





The next time you use the form you now have a Pick List button. If you click on this button it will open a window listing all the available entries in the source table.

1) Enter lookup criteria using the the (1) global find which filters all the visible columns.

2) Enter filter criteria at the top of each column

Click OK when you have completed your look-up.

The selected record form the Automobile table is used to populate all the fields in your custom table.

cascade dropdown, cascading drop down, cascading dropdown
See also