AnsweredAssumed Answered

Merging databases with multiple tables

Question asked by debbie_geiser on Nov 8, 2018
Latest reply on Nov 12, 2018 by DavidJondreau

I'm trying to merge several databases into one.  First off the customized database I use is for registering members and tableholders for a vendor/attendee show.  I used 4 stand along computers with a copy of the database on each desktop and registered members and vendors for the next show.  When I attempt to import the data from the stand along computers I can't get the import window to show all the necessary fields that need data imported into. 

AS you can see from the screen shot, the last 3 fields on the left don't have matching fields on the right.  When I try to change the target field to another menu they are all grayed out.  I've tried saving the data in both FM & Excel files without success.  I've tried every option possible for importing the data and spent 2 hrs. on the phone with FM support.  I've searched youtube, FM knowledge base but none of the suggestions work.  The database has many tables, fields, and relationships. see attached.

 

Any help would be greatly appreciated.  Thanks.

Outcomes