coasterman
Registered User.
- Local time
- Today, 12:30
- Joined
- Oct 1, 2012
- Messages
- 59
I am working from an existing database which is just two table. The main table has a massive amount of redundancy and duplication and needs splitting into, at first glance, 5 tables.
After I have run my various make table queries and added a Primary Key and FK field to the new tables how do I populate the FK with the Parent PK.
I thought I could simply add all the fields from the new table and then create an adhoc join in an update query to populate the PK to the FK. When I do this however I get "You are about to update 0 records"
Clearly I am doing something wrong so any advice would be appreciated.
P.S I have tried the table analyzer but it doesn't give the correct options to split the table the way I need.
After I have run my various make table queries and added a Primary Key and FK field to the new tables how do I populate the FK with the Parent PK.
I thought I could simply add all the fields from the new table and then create an adhoc join in an update query to populate the PK to the FK. When I do this however I get "You are about to update 0 records"
Clearly I am doing something wrong so any advice would be appreciated.
P.S I have tried the table analyzer but it doesn't give the correct options to split the table the way I need.