473,320 Members | 1,957 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

How to copy 1 table field to another table field.

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
3 5216
missinglinq
3,532 Expert 2GB
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
hi, linq,

thanks a lot & much appreciated. :)

regards,
styled
Feb 16 '10 #3
nico5038
3,080 Expert 2GB
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

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

Similar topics

1
by: middletree | last post by:
I have a table which has a datetime field for when a row in this one table (Ticket) was created. This is for trouble tickets for a help desk. After a ticket has been created, any additions to that...
4
by: sparks | last post by:
1 need to copy the data in one table into another...but its from another database. tables are demographics and testdata database1 database2 demographics personid personid same...
0
by: gary b | last post by:
My forehead is sore from beating it against the wall. Can anyone help? I've started drinking again because of this problem! Setup: ContestantTbl = table ('one' side) HorseTbl = table ...
1
by: Sean Howard | last post by:
Dear All, As is my want I need to do something in Access that seems simple but cannot fathom out. I have main form with two subforms, both datasheets with an almost identical table structure....
5
by: Clodoaldo Pinto Neto | last post by:
Hello, How to make sure COPY TO writes the table lines to the file in the same order they were inserted? I'm producing html pages in pl/pgsql and using COPY TO to write then to file....
9
by: David Rysdam | last post by:
I have a large amount of data that I copy in and out of Sybase very often. Now I also want to copy this data in and out of postgres. I have an existing script that creates the entire database(s)...
2
by: Swinky | last post by:
I hope someone can help...I feel like I'm walking in the dark without a flashlight (I'm NOT a programmer but have been called to task to do some work in Access that is above my head). I have...
4
by: colmkav | last post by:
Hi, I need to copy a linked table but without keeping the link. ie all the data and settings accept for the link to another db. How can I do this? Colm
2
by: VooDoo | last post by:
Hi, i am trying to copy a completed field set from one table to another. I am using this SQL command: INSERT INTO doc_valid SELECT * from doc_temp where id=$id it works, but it also copy the...
2
rightclick
by: rightclick | last post by:
I am setting up a database to be used to keep a point ranking system for my table tennis school. I have a table tblMain with records for each player. It includes a field called StartOfSeasonRank....
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.