access 2007, how do related tabled get updated at the same time
Posted on 2010-09-17
I know this is really an "Access 101" type of question, but I made some changes to a database recently (took one giant table of info and broke it into several related tables) and can not get them to work together the way I think they should.
I have a DB w/1 main table and 8 "sub" tables that are directly related (1-1, enforce ref int, cascade up/down) and my question is:
Can one query be created that will automatically update each related table simultaneously with a replication of the new record ID/Community Name so that when basing a Form on that query, I am able to complete the form to the end w/o getting the following error:
The Microsoft Access Database engine cannot find a record in the table 'CommunitySurvey090210TBL' with key matching field(s) 'CommunityID'.
I have included a sample of the DB to demonstrate.