I Have two tables
tblCustomers
tblDeals
I Have a main for which is linked to "tblCustomers" and a SUBFORM that is linked to "tblDeals" both have a common link to CustomerID from the tblCustomers table, and a One to Many relationship. This is fine; however...
When I open the main form it creates one record in the tblCustomers table and two records in the tblDeals table..ANy one have any suggesstions on the remedy for this..
Thanks
Jeff
tblCustomers
tblDeals
I Have a main for which is linked to "tblCustomers" and a SUBFORM that is linked to "tblDeals" both have a common link to CustomerID from the tblCustomers table, and a One to Many relationship. This is fine; however...
When I open the main form it creates one record in the tblCustomers table and two records in the tblDeals table..ANy one have any suggesstions on the remedy for this..
Thanks
Jeff