Jump to content
Sign in to follow this  
Robert Collins

Creative use of a tool tip

Recommended Posts

I have recently been finding useful ways of using tooltips . I have a use for one, but I just can't work out how to execute it.

In one table I have a field showing a numeric value (a £ amount) and in a related product table I have products that have a retail price . I would Like the tooltip in the first table (sales) to show all the product descriptions that retail up to the amount in the sales field

ie

sales Field = £270

tooltip shows products (stored in Product table) that retail from £0 to £270 and not above.

I'm not sure if this is too ambitious

Any help would greatly be appreciated

thanks

Share this post


Link to post
Share on other sites

It's going to be impossible to do with Filemaker 7. I'll assume you have an Advanced version of 8 or higher.

You need a second table occurance of the Product table. Relate it to the Sales table like,

Sales::Sales Field > Products::Price

You'll probably want to sort that relationship, by Price or Description.

If you have 8A, you'll need a custom function like GetNthRecordSet() to simulate what List() does in 8.5A and 9A.

And set the tooltip to List(Products2::Description).

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

×
×
  • Create New...

Important Information

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