|Subject:||blank records in a relation table....can't figure out why|
|Posted by:||sparks (jstaln…@swbell.net)|
|Date:||Fri, 11 Aug 2006|
I am trying to fix a database that someone did about 4 yrs ago in
The main table just contains demographics and is on the main form of
It has a subform on a tab that contains the other information.
it is set 1 to 1 in the relationships.
simplify if I can
table 1 and table2
main form table 1
subform table 2
when you create a new record and enter a id number on the main form
you have the correct info in table 1 and table 2 has a blank record.
you again put in info in main form and enter data in in the subform.
you have a record in table 1, a record with the linked id in table
to...all looks ok but then I again have a blank record in table 2.
I tried to see if they had some type of requery in the forms or maybe
even some default value or something but it seems that when you add
a record and type in anything in the main form a blank record is
created in the subform table at that instant.. and when you enter
something in the subform a correct linked record is created.
but for the life of me I can't figure out why the blank record is
created in the subform table.
any ideas are greatly appreciated