One to Many Relationship Without a Portal

[cj247]

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

[Ender]

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 ]

[cj247]

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....

[Ender]

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.

[cj247]

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.