I wish I knew

I am running a script that populates a field with a picture according to another field's value from a value list.

My problem is that it will only do one record at a time. I need to run the script from each record then all is fine.

My teachers will be using only records associated with their class (another field)

Is there a way to get the script to populate all records without compromising the fact that they are working with a specific group?:?

Any thoughts would be greatly appreciated

Many thanx

Poida

Hi,

Do you mean for each value from your value list, or for all records from this database ?

If the value list is related, work with combination of globals and loop scripts within both the related files and the Main file.

If it is for all records of the Main file, a loop script in the Main file with a next record step and a global to store the image...

1. why a script? a calculation will do as well

Case(field1;"auto",pixauto,"bike",pictures::bike, "train",getrepetition(g_pictures,2,"").

Make sure the calc results in a container.

2. scripted

go to record, first

loop

if field1="auto"

setfield, picture,pixauto

end if

if ....

...endif

go to record,next, stop at last record

end loop

3: or do a lookup based on a relation