we need help with a script to show container data from database #2 in Data base #1

we want the file to show a picture from Each of the Container Recorders at the botom of Data base #1 and loop. Like a file of baner ads.

Start as soon as you satart thr data base

Get Container File's from Data base #2

Show each picture one at a time ( pause/Resume 0:00:05 ) In Database #1

LOOP

until the data base is closed

Try using a portal and in the pause loop have a Go To Portal Row.

It sounds like you have them relational -- this is good.

Use this script (Display Images) to display the images in the images database:

Allow user Abort [off]

Freeze Window

Go to layout [image display]

Loop

Go to Record [first]

Pause/resume Script [00:05]

Go to Record [next, exit after last]

End Loop

--

In the "main" database, create this script;

Allow user Abort [off]

Freeze Screen

Go to Related Records ["image relationship", show only related records]

Perform Script [External - Images, Display Images]

Refresh Window [bring to front]

--

Run the script in the main database to see the images. I'd bem reluctant to make the script run continuously without some sort of break option (other than quit).

If each record in #2 has an i.d. field with a serial number in it, you could make a relation in file #1 from a global field to the i.d., then increment it in a loop:

Set field [gID, 1]

Loop

. Go to field []

. Pause...

. Set field [gID, gID + 1]

. If [isEmpty (gID::container)]

.. Set field [gID, 1]

. End If

End Loop