I am building a customer call log in MSAccess and want to track calls for our Customer Base as well as our internal representative base. My plan is to have the user enter an account number or select from a combo-box, click a button and call up a form/subform. Form will show some basic account info (acctNo, Name, Contact, Addrs, etc... ) and subform will be a running call log.
My problem is I have 3 externally sourced tables I'm pulling this information from. One table holds all of my Rep info (account, name, address, etc...) and the other two tables hold all of the customer info I'd need (also account, name, address, etc...).
Is it possible to merge the separate sets of account data into one table, which I'd then use to bind my various forms? external tables are read only while new merged table would allow the ability to add standalone records, etc... modifications to existing records would only be done on the external source with linked data getting updated from that source.