Multiple Table Query Problem
I have split up a large order entry table into several smaller tables that are related to the main order entry table. When I add the first support table to the query which has my main order entry table everything works fine and I can add records to the query. The problems comes when I add my second support table to the query, the query does not let me add new records to it.
Each support table is linked to the main table using the main tables promary as a foreign key.
Any help would be appreciated.