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

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).

Thanks for the info ,I know where i'm going now, and yes I do have FM9 Advanced (i must change that profile)