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.
I figured it out! I need to import from my central database not from the external database.