i need to write a script that...needs to do a find and print for each memeber of a value list.

example: there are several job records, and each one is assigned to a certain person from said value list(joe,billy,sue). when the manager hits print there needs to be a print off of all joe's jobs. then another print off for all of billy's and another for sue's.

but it needs to be flexible because names may be added or taken away from the value list at anytime.

Hey VICH!

If you have (or create) an Employees table, you could relate Jobs to each Employee. You could display those related Jobs through a portal if you like, of course.

More importantly though, you could script the printing scheme you're needing. It would require a Loop and a Go to Related Records step.

From the first record in your Employees table (say, "Joe"), the script would go to Joe's related Jobs (preferably in a separate window) and print the Jobs layout. That separate window is then closed, and the Loop advances to the next Employee record ... rinse and repeat as needed.

Does that seem workable?

but it needs to be flexible because names may be added or taken away from the value list at anytime.

... and an Employees table could serve as the source for your ever-changing Value List!

Edited October 3, 200619 yr by Guest
because I was too hasty

does seem workable....

alittle more round about then i was hoping...but i don't see any more options.

thanks for the input i'll see what i can do with that.