FC2Video

Foreign Key Data Selection is a useful tool that allows you to easily get the foreign key value from the reference table. It significantly reduces the time that would take to look for available values from the master table. In this tutorial, we will show you how to employ this feature. First, select the child table and set the foreign key constraint in “Design Table”. Then, select the “Foreign Key” tab and add the key. After setting the foreign key constraint, open the table in table view. Click on the “…”(ellipsis) to open the data selection window. By default, it shows 100 records per page. You can control-click anywhere on the grid and select “Show All” to show all available values. Also, clicking on the “Setting” button will show additional columns of the master table. You can then select the column name on the left panel. If you want to search for particular records, just enter a value into the edit box and click the “Filter” button. Finally, double-click to select the desired data and value to be inserted in the table view.