This will directly affect how our application will be generated in the final exercise. We will now look at 'fine tuning' the dictionary in the Dictionary Editor.

Now that everything is set up, click 'OK' to create the relationship.Įxercise 4: Add a Lookup Table Clarion documentation often confuses tables and files, because with TopSpeed they are much the same. The generated source code will automatically maintain referential integrity between the tables. Choose 'Restrict' from the 'On Delete' dropdown list. In the Referential Integrity Constraints group box, choose 'Cascade' from the 'On Update' dropdown list. It is a good idea to give linked fields the same name where possible. Finally, click on 'Map By Name' (because the field names are the same) so they relate correctly. This release offers major enhancements to the supported SQL syntax and conforms to the ODBC 1 specification with many. Choose the 'ORDER' table as the foreign table and 'KEYCUSTOMER' as the foreign key. TopSpeed ODBC Driver Access TopSpeed Databases Using Database Query and Reporting Tools topspeed odbc driver topspeed odbc driver SoftVelocity has just released an updated ODBC driver for accessing TopSpeed (.TPS) data files. Use the Tab key to move to the next field. For the 'CUSTOMER' table make sure the relationship type is 1:MANY and the primary key is 'KEYCUSTOMER'.