Was this helpful?
Change the Default Form Display
By default, Vision creates a field on a frame's form for each column (or table field column) in the Master and Detail table. Vision also includes each column as part of the frame definition when it generates the code for a frame.
There are two restrictions on displaying columns:
You cannot display the join columns in the Detail table, because they are duplicates of the join columns in the Master table.
You must display the column that joins the Master or Detail table to the Lookup table—although you cannot display the join column of the Lookup table.
If you do not want the user to see this column, you can edit the form to make the column invisible. See Modifying Vision-generated Forms for more information on editing forms.
Besides the default action, you have two additional options for specifying the display of columns:
If you do not want to display a particular column on the form or include it as part of the query, mark that column as n (do not display) on the visual query display window.
When Vision generates the code and the form for the frame, it ignores any columns marked as n (except in certain cases on Append frames, as discussed in Defining Append Frames).
If you want to include a column in the generated code but not display it on the form, mark that column as v (create a local variable) on the visual query display window. Vision creates a local variable based on this column that you can use in several ways, as discussed in Using Vision Advanced Features.
The value of the local variable is determined by the values of the current row of the database table of which its column is part. When these values are changed (by a user selecting the next Master table record, for example), the value of the local variable changes along with the values for the displayed columns of the table.
To change the default display of a column (or table field column)
1. Position the cursor on the name of the column in the visual query display.
2. Tab to the Display on Form field.
3. Type n or v.
In the preceding figure, the "order_total" column of the Orders table has been marked as n for a non-displayed field.
Last modified date: 01/30/2023