Very Simply, Two databases. One for movies one for theaters. A movie is playing at multiple theaters (a theater hosts multiple movies, for that matter, but I'll keep my question "bite-sized"). I want a field to list these theaters (theater 1, theater 2, etc). I have a list of the theaters in a portal, but I need to format an export that is a comma delimited list.

Anyway, I stripped down my examples to the bare minimum, I hope that someone can help, thanks in advance.

FileMaker Version: 5

Platform: Mac OS 9

That icon looks familiar...

Create a Global text field in theater. Use a script to loop through each record, appending a comma and the theater to the global.

Set Field [ gTheaterList , gTheaterList & ", " & theater ]

Thanks for the response, although I'm still a little confuzed.

"Use a script to loop through each record" I'm assuming a find script based on movie titles (I guess ID's would work better). So that, I get.

"Set Field [ gTheaterList , gTheaterList & ", " & theater ]" is what has me scratching my head. What is gTheaterList? (Global Field Theater List, I'm assuming) What is the process by which it keeps repeating itself?

Thanks again for the help....

A script like this is used to build the global with all the records' values from the theater field.

Go to Record/Request/Page [ First ]

Set Field [ gTheaterList , theater ] //sets the first theater in the global

Loop

Go to Record/Request/Page [ Exit after last, Next ] //goes to the next record

Set Field [ gTheaterList , gTheaterList & ", " & theater ] //sets a comma and the next theater in the global

End Loop

The result will be "a field to list these theaters (theater 1, theater 2, etc)" in comma separated format.

Thanks, that works great. I actually made a mistake in copying it. Made it work with portal rows. I'll maybe try records too.

Again, thanks so much for your help.