Character-based Querying and Reporting Tools User Guide > Character-based Querying and Reporting Tools User Guide > Using VIFRED > Create New and Duplicate Forms > Ways to Create Forms that Use Multiple Tables
Was this helpful?
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.
Last modified date: 04/03/2024