AccessPractice
Registered User.
- Local time
- Today, 15:40
- 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
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