By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
425,863 Members | 853 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 425,863 IT Pros & Developers. It's quick & easy.

New Records to Several Forms

P: n/a
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!
Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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!

Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.