AnsweredAssumed Answered

How to import related records

Question asked by on Jul 29, 2014
Latest reply on Jul 29, 2014 by

There are 4 databases in my company containing prospective business information. I need to script a way to import the "pending" records from these 4 databases into one central database. I have created a database containing 10 fields and added the 4 external databases to the relationship graph. They are related through a global containing "Pending" in the central db and the status field of each of the 4 databases. I need to build a script that will dump any current records in the central database then import the pending records from the four. I was hoping to do this using the Go To Related Records feature, but everytime I import, it imports all the records in the external database not just the Pending. Any assistance would be very much appreciated.