Importing a very different database
I have copied an old Access Database that is a basic customers/invoicing/payments style.
However the old databse worked in a different way, so I am having a bit of trouble on how to imported records.
The new FM database has the usual Customers--Invoice Details--- line items---- products
The old one appears to have an invoice table that contains a combination of invoice details and line items..with of course the customer ID number that links it to its customers' table.
How should import these into my tables if it is possible? At the very least, I want to be able to look at a customer's history to see how many invoices/numbers/prices etc it relates to..I think extracting the intergrated line items into my seperate lines table will be too tricky..