AnsweredAssumed Answered

Need Help Merging Data from Two Databases into One Database

Question asked by fredmckinnon on Jan 26, 2010
Latest reply on Feb 4, 2010 by satellite_1

Title

Need Help Merging Data from Two Databases into One Database

Post

Hey Gang,

 

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

item_no

price

map_price

qty_available

upc_code

 

Database 2:  Full Inventory

item_no

vendor_sku

MSRP

brand

category

title

description

upc_code

length

width

height

weight

 

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!
Fred 

 

Outcomes