Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

Hello jocko1,

1) Add a Listbox control to your Form
2) Right-click on the Listbox control and select the option "Control..."
3) In the Properties dialog that pops up, in the tab "General", set the option "Dropdown" to Yes,
4) in the tab "Data":
    set the "Data field" to the name of your bound field from table 2,
    set the "Type of list contents" to Sql,
    set the "List content" to an SQL select statement like: "SELECT 'FIELD1', 'ID' FROM 'TABLE1'"
    set the "Bound field" to 1      ( referring to the field 'ID' in the SQL statement above )

Hello jocko1,

1) Add a Listbox control to your Form
2) Right-click on the Listbox control and select the option "Control..."
3) In the Properties dialog that pops up, in the tab "General", set the option "Dropdown" to Yes,
Yes
4) in the tab "Data":
    set the "Data field" to the name of your bound field from table 2,
    set the "Type of list contents" to Sql,
    set the "List content" to an SQL select statement like: "SELECT 'FIELD1', 'ID' FROM 'TABLE1'"
    set the "Bound field" to 1      ( referring to the field 'ID' in the SQL statement above )