Error! Not all fields required by foreign key are selected for conversion
Error! Not all fields required by foreign key are selected for conversion

"Error! Not all fields required by foreign key are selected for conversion" - Foreign keys can be converted only with corresponding fields. This error message implies that fields required for particular foreign keys are unchecked. Look at the right panel where Foreign Keys options are shown. Check necessary fields if you want them to be converted with the foreign keys.

Example: Clicking at "RelationDict1RelationTable" primary key you get the message: "Error! Not all fields required by foreign key are selected for conversion". Look at "Fields" list control in the right panel. Here you can see the path to the fields that are required for this foreign key but they are not selected. We can see that we need RelationTable.ID1 and RelationDict1.ID to be selected for conversion.

Now make sure that both fields are checked for conversion. As we can see "ID" field in RelationDict1 table is unchecked.

If you check the checkbox in front of "ID" field the error message will be moved away.

Back to Errors and Warnings page

© Copyright by DMSoft Technologies, 2001-2008.