multiple tables to one form not updating...

Hi,
I am probably missing something obvious here. I have personal data for a
form broken down into 7 different tables since there are so many fields. The
PK is the SSN# in the first table, [tblDataSheetPersonal1]. All other tables
are linked to the first one via a one-one relationship, on the PK, with
referential integrity and cascade update/delete selected. The SSN# field is
also in all the other tables, so they can be linked.
My query, qryDataSheetMain, pulls them all together, and the form,
frmViewPersonnelMainDetails, displays all the fields on one form, with a 7-
tab feature, because they want it to be on one easy page.

Problem is, when I add data to the form, to include the SSN# and Name etc, it
only updates the data on the first table, not the rest of them. When I run
the query, it shows no record created.

Any idea how I might be doing something wrong here?

Thanks

--
Message posted via http://www.accessmonster.com

You need the main form based on the table or a query with only one table. The
other tables need to be based on individual subforms, probably one per tab.
That way Access will populate the SSN as needed on the other tables.

But first I'd double check to see if the data could be better normalized. Is
there any repeating data? Do you have something like year columns going
across?
--
Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.


"pclis007 via AccessMonster.com" wrote:

Hi,
I am probably missing something obvious here. I have personal data for a
form broken down into 7 different tables since there are so many fields. The
PK is the SSN# in the first table, [tblDataSheetPersonal1]. All other tables
are linked to the first one via a one-one relationship, on the PK, with
referential integrity and cascade update/delete selected. The SSN# field is
also in all the other tables, so they can be linked.
My query, qryDataSheetMain, pulls them all together, and the form,
frmViewPersonnelMainDetails, displays all the fields on one form, with a 7-
tab feature, because they want it to be on one easy page.

Problem is, when I add data to the form, to include the SSN# and Name etc, it
only updates the data on the first table, not the rest of them. When I run
the query, it shows no record created.

Any idea how I might be doing something wrong here?

Thanks

--
Message posted via http://www.accessmonster.com