Jump to content

Second Value Display!


tmas73

This topic is 5487 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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

Link to comment
Share on other sites

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.

Picture_2.jpg

Link to comment
Share on other sites

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 )

Link to comment
Share on other sites

  • 4 months later...

This topic is 5487 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.