Greg
The foreign keys are set when you configure Dadabik through the admin panel, not when the tables are created in SQL.
From the admin panel, select the table you wish to insert the foreign key link (in the section titled "Configure the DaDaBIK Interface for the table .....") and select "Change Table". Once the page refreshes, select the link "interface configurator" in the paragraph under the "For this table enable:" line.
Once in the interface configurator, you can select the field you want to add the foreign key to. To set the foreign key, you will fill in these fields:
Field type -select_single
Primary key field -record or ID field
Primary key table -table name you are linking
Linked fields -the field you want to display
Order by -ID or linked field name depending on how you want to order the drop-down list
When you insert/update records, you will now have a drop-down picklist of items from the other table to choose from.
I'm in the process of creating a sample database which will include the dadabik tables so users can see how the setup looks. Should be done over the next couple days and will be titled "Sample DaDaBIK Database" in the forum.
Debbie
(Latest version of DaDaBIK when this message was posted: 3.0)