New Records to Several Forms

[Coy Howe]

What is the best way to enter a new record and have a common ID # or
Social Security #, for example, populate several tables at the same
time? I have a main table with an auto number and a dozen attached
tables with numbers. They all have a 1 to 1 relationship that cascades
info from the main table. I have tried several ideas (update queries,
etc.), but always seem to run into a "key violation," or similar
problem.

Thank you,

Coy
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

[Steve]

Your tables need to look like this:

TblMainTable
MainTableID
<<Fields>>

TblAttachedTable1
AttachedTable1ID
MainTableID
<<Fields>>

TblAttachedTable2
AttachedTable1ID
MainTableID
<<Fields>>

repeat for other attached tables.

To enter data you need a main form and one or more subforms. The main form
is based on TblMainTable and each subform is based on one of the attached
tables. You set the LinkMaster and Linkchild properties of each subform to
MainTableID and as you enter data in the subform, Access will automatically
fill in MainTableID in the subform with the same value as MainTableID in the
main form.
--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
re******@pcdatasheet.com
www.pcdatasheet.com
"Coy Howe" <cf*@olypen.com> wrote in message
news:41**********************@news.newsgroups.ws.. .

What is the best way to enter a new record and have a common ID # or
Social Security #, for example, populate several tables at the same
time? I have a main table with an auto number and a dozen attached
tables with numbers. They all have a 1 to 1 relationship that cascades
info from the main table. I have tried several ideas (update queries,
etc.), but always seem to run into a "key violation," or similar
problem.

Thank you,

Coy
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!