Splitting a large MS Access table and importing into FM
I have a large (120+ fields!), messy table in MS Access and have been looking at ways to import the data into FM Pro 11 Advanced. The PK is a 3-digit number that we also use as the Contract No. I'm not convinced that my first attempt at solving this is the best way so I thought I would try to get some advice before going any further.
I have split the table into 10 separate parts by creating queries to extract information into contacts, addresses, services, suppliers etc. Each query has the same 3-digit PK code and I've exported these to CSV files.
I'm not sure how to tie all these individual tables back together again using relationships. Do I need to create new FK's then delete the original PK's in these sub-tables?