If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
multiple tables to one form not updating...
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 |
Thread Tools | |
Display Modes | |
|
|