Inserting and Removing Joins
Vision uses the following rules to join tables in a visual query:
• Master and Detail tables are joined on each natural join (columns that share the same name, data type and length).
This means that Vision can join columns that appear to be the same, but that really contain different information; for example, a store address in a Master table and a customer address in a Detail table.
• Lookup tables are joined to their associated Master or Detail table on the first natural join.
You use the Visual Query Editor to add or delete joins. You must specify the correct joins so that Vision generates the correct query for a frame. Also, the join column to a Lookup table determines the column that activates the ListChoices operation for users.
For Lookup tables, you first must remove the default join before specifying a new one.
The Visual Query Editor warns you if you try to exit without any joins specified between tables. You cannot compile or test the frame until you correctly specify the required joins.
Last modified date: 08/14/2024