How can Append Results of 2 Lookups?

Hi,

I used Eval (DBLookup) in Script to obtain a result set of names for Primary safety reps and a second result set of Backup safety reps.

I need to combine the two result sets into one to use for Authors field and mailing notices.

Does anyone have good idea how to easily combine these 2 sets into one?

Thanks,

Tim

Subject: How can Append Results of 2 Lookups?

what have you tried so far? It’s easy to ask for help but it’s much more rewarding to figure it out on your own.

Take a look at ArrayAppend

Subject: RE: How can Append Results of 2 Lookups?

Thanks Paul. This is what I need.

Had wrestled with this for couple of hours using loops and trying to concatenate the results - always hitting some roadblock.

Might have heard of ArrayAppend a while back but had forgotten all about it.

Thanks again for steering me in right direction.

Tim