HTH You can create/import the original table simultaneously using Import File>New Table(from drop-down at the top of the window), hopefully your field names are the first record and you are using a serial counter as the primary key. If so, once imported you can create a layout of just those fields(including the Primary key) you want for the next related table(s). Export those fields from this layout and import them into the new table. Your primary key field should now be the foreign key in this new table. The new table should have its own primary key. Follow? Sabenah K. Casey, Associate Court Clerk Network Center - Database Division New York State Supreme Court 100 Centre Street Room 1131 New York, New York 10013 TEL (646) 386-3940 [EMAIL PROTECTED]
>>> Ron <[EMAIL PROTECTED]> 3:42:45 PM 6/6/07 >>> I may be missing something easy here, but I have a FM table with 463 fields.I have redesigned this to be a proper relational database and now want to import the data from the original table into each of the appropriate new tables.In using Import, it seems that I have to define a table just like the original, all 463 fields, to import it, before I can use more imports to distribute the data. I expect there is a serious lack of understanding but that*s all I get out of my book!Any help appreciated! Ron Carr
