Linking graphics to field options

[treelily]

Hi!

I am trying to program file maker to link a unique logo to a a specific name in a text field. I have placed 3 name options in the text field, using the pop-up list function in the field format box. I would like to link a different logo to each of these 3 different options. Can anyone tell me how I can either do this, or suggest how I should search for my answer in the archives?

Cheers!

m

[QuinTech]

Hi, treelily, and welcome to FM Forums!

Your best bet will probably be to make three container fields: logo01, logo02, logo03. Then make a calc container field, with the calc:

Case( 

  theTextField = "Use Number 1", 

   logo01, 

  theTextField = "Use Number 2", 

   logo02, 

  theTextField = "Use Number 3", 

   logo03 

)

where "Use Number 1," "Use Number 2," and "Use Number 3" are the items in your value list.

HTH,

Jerry

[treelily]

thank you for the quick reply. I have created a new container field for each logo (however I'm not sure how to connect the logo to the new field), and when I apply your formula to the new calculation field, I receive an error messgae saying "This field cannot be found".

What am I doing wrong?

cheers!

[treelily]

Hi Jerry,

I had a symbol in my text field, which caused the error message to arise.

Thank you for your help!

-m

[treelily]

I was able to link a graphic to only one record. I had created a container on my first record, which then the calculated field was able to read from. But when I created a new record, the graphic was no longer linked to the calculated container on the new record. How do I allow each new record to read from a database of 3 graphics, each graphic affiliated with a keyword. Would i need to create a new FM database, which would have 3 containers, each with a seperate graphic, on 1 record in the new database, and then create a relationship which points my current database to these different containers on the new database? Am I thinking in the right direction?

help!

-margaret

[treelily]

conclusion: My goal was to have a calculation container that displayed a graphic depending on the value of another field, and have this be referenced in new records. My problem was that i created my referenced graphics in a container field rather than in a global field, selected to be a container. Plus in order to have the graphic to be referenced in the original calculated field, i had to section a part of the layout to include the referenced global fields with the referenced graphics in them. Of course, i would rather not have these graphics appear to the user, and be invisible, but one step at a time right?

[QuinTech]

Would i need to create a new FM database, which would have 3 containers, each with a seperate graphic, on 1 record in the new database, and then create a relationship which points my current database to these different containers on the new database? Am I thinking in the right direction?

This is the "correct" way, but what you wrote in your next post would work as well. (Sorry for neglecting to mention that the containers should be global. My bad.)

I say the first way is "correct" because it corresponds more truly to the traditional relational structure, but that is probably a very fine point that you don't need to worry about in this case.

J