Options - Row Display / Update

These options relate to the Row Display / Update window.

Get values from Foreign Keys

This relates to the use of the Get Values button.

• When this option is not checked, AQT will get the existing values of the column from the table.
• When this option is checked, AQT will see whether a Foreign Key has been defined on that column. If so, it will get the values from that foreign key column.

Note that for some databases, particularly Oracle, obtaining information on Foreign Key relationships can be very slow. Consequently we suggest caution when using this option with such databases.

User Defined Relationships

If the table has some User Defined Relationships, AQT will look at these as well as any Foreign Key relationships.

If you have checked Options > General > Get Related Table Information from User Defined Relationships only then AQT will only look at User Defined Relationships, and not at any Foreign Keys. This is a useful option for databases such as Oracle, for which the Foreign Key query is slow.