AnsweredAssumed Answered

Importing a very different database

Question asked by willrollo on Sep 26, 2012
Latest reply on Sep 26, 2012 by willrollo

Title

Importing a very different database

Post

     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..

     Thank you

Outcomes