Our customer has a problem, he has converted a native 3.70 database to sql 2000.
In the native db, the table contact was set open (DataPerCompany=No).
Now he wants to use the function Maintain Relationships (File > Database > Alter > Tab:Intergration).
When using this function the following error occurs:
The Microsoft Business Solutions-Navision Tablerelation properties and Sql server foreign keys have not been synchronised successfully.
The contact table references a table in the TableRelation field property of the Salesperson Code field that does not exists.
One solution is that we set open (DataPerCompany=No) all tables wich are linked to the contact table, but this is not a desired situation.
Is there a solution to handle this problem without opening all tables
Thanks in advance!