The primary key is not being inserted in the secondary table while other data is being inserted in SQL server 2016 , the strange thing is that when tabbing or using tab the data from the child form will go or disappear leaving the data from the main form . I'm using the same tables , same form , same queries as in ms access , I tried to recreate the form still nothing is working out , I have just re exported the tables again to sql server still nothing is being sorted out.
I have not recreated the relationship in sql server since the export went with all the links except the date which I had to normalise to datetime
What should I do now????????????