Create new linked tables from single flat table

[ZOR]

I have a flat table which is populated. I need to break it up into 3 related tables. Is it possible to do it with queries or code. Thanks

 

[dhookom]

Yes. To get a more complete answer, please provide more complete specifications.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[ZOR]

i have 2 unrelated tables. The first has multiple (duplicated) entries of a Barcode Number and other unique fields of data, the second contains records for each Barcode,together with different unique data.

I want to convert individual tables to 3 related tables.

Table1
ID1 Primary Key
Barcode Number

Table2
ID1 (Foriegn Key)
ID2 Primary Key
Fields currently in old table 1

Table3
ID1 (Foriegn Key to table 1)
ID3 Primay Key
Fields currently in old table 2

As I know primary numbers, can I do a copy of a table and insert a number field and hand enter numbers, and then treat that field as a foriegn key. Have a feeling in the back of my mind that I wont be able to set the join 1 to many later, might be wrong.

Thanks

 

[ZOR]

Think I fixed it. I did a new table with unique bar code numbers in, plus a primary key. I then did a make table query having the two tables in and copied the primary key into the second table as a number, I was then able to use that field as a foreign key to join the two tables. Hope thats exactly what I did as I wasn't logging everything, and more surprised when it worked. Thanks