value list with associated container field

[tommypmadison]

Hello,

I have a value list with 20 soccer teams....for each team I have a graphic in a container field representing their jerseys...my question, is if I can have FM automatically pull up the graphic of the jersey when I select the team from a pop-up menu.

I am trying to make a weekly schedule of the games that would graphically show the team jersey along with the team name when selected. Anyone have any suggestions on how to accomplish this??

Thanks,

Tom

[bcooney]

What tables do you have and what are their relationships to each other? On which table is the layout based when you select the team name?

Seems like if you have a relationship from the table used for the layout to the table that holds the containers by teamID (or name) you should be able to place the related container right on the layout.

[tommypmadison]

Hey thanks for the tip, it is working great! :laugh2: