How to write a script to search another database,then add results of search
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!