Trying tom sort out how to creatye a (dynamic) dropdown in a form.
Like the the one wich is mentioned in the "demos"section.
I cannot find a "readable" and easy FAQ.
Hope anyone could help me with an example
These are the steps
Put a DB Multi Record Loader in your form Events.
1. Select the table were the fields are stored.
2. Give it a Model ID
3. In the advanced tab
4. Select Load Data =Yes
5. Data Load Type = ALL
On the Data Displayer set Enable Date Displayer to No
If you want to display then in alphabetical order Put the following code in the Where statement: 1 ORDER BY 'the_field_to_be_displayed'
The 1 and the single quotes are necessary.
Next put a Drop Down on you form.
1. Give it the appropriate fieldname of your dataset (loaded with a DB Record loader, not the DB Multi Record Loader). The syntax is ModelID[fieldname]
2. Select the Dynamic Data tab
3. Enable = Yes
4. Data path is the Model ID of the fields to be shown (form the DB Multi Record Loader)
5. Value key is the field you want to be stored in you table
6. Text Key is the field you want to display
Rob
Hi Bob,
With the 1st FAQ and the topic started by Ria58 it's clear now and I have created a triple drop-down.
This topic can be closed now.
@RobP:
Bit puzzled as I don't understand waht you mean by "table", what kind of...