enter data to different tables through one form

[kumar]

i have 5 tables. all of them has pers_no as primary key. they have one to one
relation ship through the primary key amongest them. i want to create one
form having a text box pers_no where i will enter the data and i want the
data to get entered in each table. so how i am not able to do that. i request
all you guys to help me. thank you.

 

[Allen Browne]

Sorry for the bad news, but that's not the right way to use Access. You
cannot write to 5 tables from one form like that.

If you are subclassing, you could create a form for entering the main form
info, and then 5 subforms (probably on tab pages) for the related records in
the other tables.

You could even use the AfterInsert event of the main form to execute some
Append query statements to add the new records to the other tables.

But if you are using 5 tables because you have too many fields to fit into
one table, you will be wasting your efforts here, becuase you will not be
able to query this database to get out the information you need. It might be
worth your time to learn about normalization, so you can create the right
tables and be able to query it.

Here's a couple of links to get you started:
http://allenbrowne.com/bin/Access_Basics_Crystal_080220_Chapter_03.pdf
http://www.accessmvp.com/JConrad/accessjunkie/resources.html#DatabaseDesign101

 

[kumar]

thank you "Allen Browne" for your help. i find this info useful. kumar