Here is the problem. I created a new .adp pointed it to the SQL server and created the database and tables. The table structure below as a sample. My problem is that one-to-many relationships are not working correctly or I should say not updatable. What am I doing wrong?
TABLE ONE...
