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

How to copy 1 table field to another table field.

P: 5
hi there,

i am new to ms access and currently i am in need of help. here is my problem i need to help create a form that allow me to update 2 tables.

example:
PERSON1 (table 1)
id
name
dob
age

PERSON2 (table 2)
id
guardian name
guardian dob
guardian age

i need to create a form that allow me to update both table at once or at least by updating 1 table (table 1), it can duplicate itself to the second table (table2).

to be specific, i need to copy the "id" from the table 1 to table 2.

please help. much appreciated.
Feb 15 '10 #1
Share this Question
Share on Google+
3 Replies


missinglinq
Expert 2.5K+
P: 3,532
This should be a One-to-Many relationship with Person2 being the One and Person1 being the Many. It is the classic scenario for using a form/subform.
  1. Make a main form, using the Person2 table as the Record Source.
  2. Place a subform control on the main form
  3. When asked by the Wizard, choose the Person1 table as the source for the subform
Access should automatically use the ID fields as the connecting field. When you enter a new record in the main form, entering the ID, a record in the subform will have the ID automatically filled in.

Welcome to Bytes!

Linq ;0)>
Feb 15 '10 #2

P: 5
hi, linq,

thanks a lot & much appreciated. :)

regards,
styled
Feb 16 '10 #3

nico5038
Expert 2.5K+
P: 3,072
It would be easier to normalize these tables into:
tblPERSON
-id
-name
-dob
-age
-role (person or guardian)
Thus you only need one form and the role can be designed as a combobox holding the two (or later perhaps more) roles.

Nic;o)
Feb 18 '10 #4

Post your reply

Sign in to post your reply or Sign up for a free account.