Ways to Create Forms that Use Multiple Tables
To create a form that uses columns from multiple database tables, use one of the following techniques:
• Create a default form based on an existing table. When the Create a Form Based on a Table pop-up appears, enter more than one table name, separated by spaces or commas. VIFRED automatically creates fields with the appropriate internal names and data display formats.
• Use a query language to create a multi‑table view or use QBF to create a JoinDef; then create a default form for that view or JoinDef. VIFRED automatically creates the fields with the appropriate internal names and data display formats.
• Create a blank form and create the fields you want, specifying appropriate data display formats; then use a programming language to link those fields to data columns in multiple tables by way of the fields' internal names.
You can use the GetTableDef operation to create a table field on the form that contains internal names and data display formats automatically corresponding to the columns in the database tables. You cannot use GetTableDef to create simple fields.