The Foreign Key (Manually Assigned) Generator generates foreign key values for a child table column based on the values contained in a parent table column. You can generate specific values for the parent table column referenced by the child table column. To do this, find the parent table column in the tree view, select the required generator and configure its settings.
The dialog box of the Foreign Key (Manually Assigned) Generator contains Basic Settings and custom settings. You can customize the generator by changing the basic and custom settings.
Table
Choose a parent table.
Column
Choose a column in the parent table. Make sure that the child table column and the parent table column have compatible types.
Note
Foreign Key (Manually Assigned) Generator retrieves data from the data generated for the parent table. If you need to select data from the same table, but use the data that already exists in the table, then you need to replace the Foreign Key (Manually Assigned) Generator with the Table or View Generator, or the SQL Query Generator from the Basic category.