Why Does Sub Form Create Two Records??

pcdummy

Registered User.
Local time
Today, 12:09
Joined
May 9, 2001
Messages
45
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
 

Users who are viewing this thread

Back
Top Bottom