Linking 'Pop Up' Fields to Databases

Popup Fields can be 'linked' to a database to allow the user to define the values that can be selected.
To accomplish this, add another form to the application where the user can edit the values.
From the Form Properties window, set it as a 'Primary Database' form, and uncheck the 'Use Default Values' box
Enter the name of the Database and Table ('CatDB' and 'Cats' in this case) in the 'Type' field

Put a Text Field on this form where the user will enter the categories that can be selected. Be sure to give this field a unique name (I used 'CVls' for Category Values).
You can add Previous, Next, First, Last, Add, and Delete buttons. Add a button to jump to another form, and don't forget to add a button to jump from one of the other forms (I added one to jump from the View URL's form).

On the Edit URLs form and bring up the Properties Window for the Category Popup Field.
Click the Radio Button marked 'Database Link'
Enter the same 'Type' and 'Creator' that you entered in the Primary Database form where the categories will be entered (the new form). Enter the name of the field where the data will be pulled from in the 'Field ID'

If the 'Link Other Fields' checkbox is checked, any fields in the Category database that match the name in the primary database will be pulled in as well. This allows pulling in more than one field from a database (like selecting a name, and pulling in the NAME and ADDR fields as well).

Here are the two screen shots for this application.
The screen on the left allows entry of the Category options.
The screen on the right shows editing a URL record, with the Popup Field showing the values that can be selected.

Š2000 PDA Toolbox