You can use the commands on the shortcut menu to change the return values in a formula table. These commands are available from the grid in the Formula Table window.
To change a value, right-click the cell and choose one of the following commands. A ü appears beside your selection.
- Use Formula returns a value based on the selected formula.
- Use Formula Table returns a value based on the selected formula table.
- Use Numeric returns the numeric value entered here.
- Use Variable returns the value based on the selected variable.
- Substitute <xxx> enables you to replace the entry in a cell. The name of the command indicates what kind of selection you can make.
- Edit <xxx> enables you to modify the database records indicated by the command name.