Importing data from old database
In my old Access Database We only had one table. So each record contained all of the client data Name address etc. My new better FM database has a client table and a jobs table. My jobs table contains all of the same fields as my old with one exception. My new data base does not store all to the repeating client data, instead I just have a Client ID field.
How can I import my old data, and somehow link the old data jobs to the new client Id in my new database?
I typically copy my old database from Access and paste it into a excel spreadsheet. FYI