1 Reply Latest reply on Jul 29, 2014 6:04 PM by kjunker@hjf.org

    How to import related records

    kjunker@hjf.org

      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.