Second Value Display!

[tmas73]

How can I display a fields second value, the tooltip just shows the first value in a value menu!

Thanks

[mr_vodka]

You probably will have to create a second TO for this.

[tmas73]

Sorry but what does To stand for?

T

[Raybaudi]

What's your actual calc for the ToolTip ?

[Lee Smith]

Sorry but what does To stand for?

T

It stands for Table Occurance.

HTH

Lee

[tmas73]

This is the calculation for the tooltip.

"Product Name:" & products_navigation::prod_name & ¶ &

"Type:" & products_navigation::prod_type & ¶ &

"Date:" & products_navigation::prod_date & ¶ &

"End Date:" & products_navigation::prod_end_date & ¶ &

"Supplier:" & products_navigation::prod_supply

[Raybaudi]

... and the field that has the tooltip is a field of the same table ( products_navigation ) or of a related one ?

[tmas73]

Yes it is in the same table but in a portal row!

T

[Raybaudi]

I think that you'll need only a 2 :)

products_navigation.zip

[tmas73]

Thanks for the file, I do have the right table in there, but the original problem I had was that the field (lookup from tooltip) is a value field that displays the second value field, but the tooltip only displays the first value field wich is a serial number.

[Raybaudi]

This picture shows some little differences from what you said about the calc for your tooltip.

BTW: can you post a stripped version of your file ?

[comment]

Why don't you simply include the company field directly in the tool tip calculation? I don't see what the value list has to do with this.

[tmas73]

Hi here a file attached! Thanks for the help!

Log: Test

Pass: 1

T

CloneDBR.fp7.zip

[tmas73]

Because it seems that it enters the number in the field but displays the linked company name in display.

[Raybaudi]

Hi here a file attached!

With a Contacts 2 ( as I said ) works.

CloneDBR.zip

[tmas73]

k thanks, why do I need a second table for this to display? I try to understand what this one table does? Thanks for the help

T

[Raybaudi]

Your Supplier ( aka products::prod_supply ) field is showing the second value of the value list "merchant" ( con_company ), but contains the first value of that value list: contacts::contact_ID.

So, to have the con_company in the tooltip, you have to keep that value from somewhere.

As in the products_navigation table you have only the prod_supply ( aka contacts::contact_ID ) you'll need a new relationship. ( or a new looked up field in the products_navigation table )

[teffjohn]

Is it possible to change the tol tip color in the windows if it so show the steps?

----------------------

teff john

dating

[tmas73]

Solved!

connect eo_materials to eo_contacts_lookup

Tooltip.fp7.zip

Edited March 21, 2009 by Guest