Merge two tables with identical fields but different records into one final table
Hi I have two offices running identical FM file with each side storing separate records. As a supervisor, i would like to monitor two offices records in one single FM file.
eg. Office A (sold item X) while Office B (sold item Y). I would like to see both records (item X&Y) both appear in the supervisor's copy of FM.
The simplest way would be to manually export records from both offices and import all into the supervisor FM file. However this is cumbersome and not dynamic.
If i have access to both separate files on my desktop, is there a way to automatically pull the data out of each FM file and auto merge the records into one complete table in the supervisor FM file?