How it works...
Creating a table creates a definition that Operations will use to create the physical table in the SQL Server. The tables are also types that contain a lot of metadata at application level.
When creating the fields, we didn't specify the label, size, or type. This comes from the EDT. We can change the label, give it specific context, but the size and type cannot be changed.
The relations we created are used at application level and not within SQL. They are used to generate drop-down lists and handle orphan records. Within the client, you can navigate to the main table. It determines the table via the relation and uses the FormRef property on the main table to work out which form to use.
The Find and Exist methods are a best ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access