2 Replies Latest reply on Oct 7, 2012 8:50 AM by paulayala

    Importing multiple excel files into one database...



      Importing multiple excel files into one database...


           I am brand new to FM. I'm running FMP 12.

           I have to use an outside client management software that my company provides and uses. The software is so old and outdated that I am using FMP12 to manage my client data. I can export data from the client software to Excel. I have to export 3 different files to get a complete profile on one client. So there is some overlapping info. I have contact info, account info, and insurance info.

           I created a FM database using the contact info as the master layout and created the other 2 tables (accounts and insurance) with relationships between them. I want to import all 3 files into this one database and use portals for a dynamic listing of accounts and insurance products per client.

           Can this be done within this one DB or will I need a DB for each Excel file? If I need multiple DBs, can the relationships be built between the DBs to prefill data imported from Excel to these DBs? Or will I need a master layout with tables for each DB then create relationships between master layout/table occurrence/db table occurrence? 

           Please help...Thank you so much!