Foreign Key Data Selection is a useful tool for letting you to get the available value from the reference table in an easy way. It allows you to show additional record(s) from the reference table and search for a particular record(s).

To include data to the record, just simply click or press Ctrl+Enter to open the editor for editing.

• Just simply double-click to select the desired data.

  

  Hint:

  By default, the number of records showed per page is 100. To show all records, right-click anywhere on the grid and select Show All. To adjust the global settings, see Options. To refresh the record, right-click anywhere on the grid and select Refresh. or press F5

• Click to open a panal on the left for showing a list of column name(s). Just simply click to show the additonal column. To remove the column(s), uncheck them in the same way.

  

  Hint:

  To set column in ascending or descending mode, right-click anywhere on the column and select Sort -> Sort Ascending / Sort Descending. Remember to remove all sorting before applying on another column. To find for the text in the editor window, right-click anywhere on the grid and select Find or press Ctrl+F.

• Enter a value into the edit box and click to filter for the particular record(s).

  

  Hint: To remove the filter results, right-click anywhere on the grid and select Show All.

Related topic:
Foreign Keys