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
resource@pcdatasheet.com www.pcdatasheet.com
"Coy Howe" <cfs@olypen.com> wrote in message
news:4127cdb9$0$14480$c397aba@news.newsgroups.ws.. .[color=blue]
> 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![/color]
New Records to Several Forms 
