Showing graphic from container field based on calculation

[Agnes Riley]

Hello All,

I have a database for tagging documents (for later use on a website.)

I have 3 tables:

Documents (ID, etc.)

Tags (TagID, tag)

DocumentTag (Document ID, TagID)

On a layout from the Documents table I have a portal showing all the possible tags from the Tags table; based on a constant relationship. Right now I have a plus sign on the left of every tag and a delete sign to the right. It's redundant. I have another solution where I was able to show red or green arrows based on whether the current stock price was lower or higher than the closing price. That was easy, because the information was in the same table.

Here every time I add a tag to a document a record gets created in the DocumentTag table with the serial number of the tag and the document.

What I'd like is an "add button" to show if the tag hasn't been added to this document and a "delete button" if it has. I have two graphics in two global container fields. I cannot figure out for the life of me what criteria I should base my calculation on to show the right graphic in a calculation container field.

Any ideas anyone?

Thanks,

Agi

Edited June 26, 2008 by Guest

[mr_vodka]

You can do this without using an additional calc fields and images via conditional formatting.

Portal_Icon.zip

[Agnes Riley]

Hi,

For some reason I didn't get an email notifying me about your response.

Thank you very much for your help. I got that working in my file. Now, if I'd like to do the same with images (cause they look nicer) I would need to have the image globals and calculation in the documents table, right?

Thanks,

Agi

[Lee Smith]

If you didn't receive an Email, it may be because you didn't [color:red]Subscribe to Topic.. This is an option you can select. It is located at the bottom of the Browser page, when viewing a Topic. After clicking on it, you are give an option of Email Notification.

HTH

Lee

[mr_vodka]

Well its not as easy to do with an image because you would have to set the global field with the DocID via a script. If you have a scripted navigation for the Documents layout then you can do it by setting the global field as part of it.

[Agnes Riley]

Thanks, John.