Foreign Key Data Selection is a new feature introduced in Navicat. It allows you to get the available value from Foreign Key referenece table.

To select data from the reference table, just simply click to open the edit box(es) for editing.

Showing additional data

To show additional data for the referenece table, simply click the Setting button and choose desirable column from the referenece table.

Searching for particular record

To search for a particular record, simply enter the value into the edit box and click the Filter button.