AnsweredAssumed Answered

How to write a script to search another database,then add results of search

Question asked by disabled_debig on Apr 6, 2012
Latest reply on Apr 10, 2012 by philmodjunk

Title

How to write a script to search another database,then add results of search

Post

Hi! This has to do with a relational database many(2) to 1.  In one of the "many" databases I want to search for a unique ID and based

on that search gather other fields then do a lookup to transfer information to the "1" database.  As there can be multiple records using

the same unique ID.  I want to make  a script step that will create on demand new records in the "1" database as needed

to house the information gathered. I am able to do a lookup, however, it only transfers the first record it comes across and I need

that step to repeat itself until all info(based on the unique ID) has been  transferred.  The reason for using the lookup is that 

even after the original data is transferred there can be changes to those records and I need to be able to keep the "1" database

updated constantly. I would appreciate any input.  Aloha!

Outcomes