Need Help Merging Data from Two Databases into One Database
First, I've researched and read the "Synchronizing or Merging Two Databases While Updating Records" article. I *THINK* this may be what I need, but I honestly get lost in it and can't quite understand it.
I have two separate database files from my distributor.
One file includes the items I'm approved to sell, and includes these fields:
Database 1: Approved Items
Database 2: Full Inventory
Now, I need to pull several of the fields from Database 2 into Database 1.
item_no would be the best field to use as a "match" (trigger?).
Is there anyone out there who would be patient and gracious enough to give me a step-by-step on how to do this? Assuming I have both files open (I'm using Filemaker 7, but assume it will still work).
I would like to pull ALL of the fields mentioned above in database2 into database 1, using the item_no field to match them up.
(this would be required instead of going the other direction, as there are items in database 2 I'm not authorized to sell ... Database 2 has over 20,000 records, while Database 1 has around 17,000)
Thanks in advance!