Update Query (1 Viewer)

AccessPractice

Registered User.
Local time
Tomorrow, 03:38
Joined
Jun 24, 2016
Messages
25
I have two tables which relate in one-to-many relationship.
In one-side table I have an autonumber field (PK). And many-side table with a number field (FK).
I want to use update query to fill in FK with PK. (there are about 600 records to fill in.)
How can I do it?
Thank you
 

Ranman256

Well-known member
Local time
Today, 16:38
Joined
Apr 9, 2015
Messages
4,339
then you must match another field....
if both fields have LAST NAME, FIRST NAME, then you can join the 2 tables on both these fields, then update the FK.

If there is no field to match, it cant be done. The FK should have been created upon the parent table creation.
 

Users who are viewing this thread

Top Bottom