I have a repeating field. Each contains a number that corresponds to an
article. I want to see the article name when I put the cursor on a
number.

I can get this to work for the first of the 10 repeats, but not the
other nine. I use a lookup to do this.

How can I get this to work for the remaining 9 repeats?

Thanks,

Rich

If I understand what you're saying, you created the tooltip by clicking
on your repeating field and entering the tip.

What you might try: create an invisible button for each repetition and
then create a tooltip for each button. Since you only want the tip to
display if there's a value in the repetition, use a Case statement to be
sure that the tip only shows when the repetition contains a value.

There may be other ways to do this, but I'm pretty sure this approach
will work.

Abbott

In article <1h6d7bu.f4dd741cnpzl0N%rich.sagall (AT) pobox (DOT) com>,
rich.sagall (AT) pobox (DOT) com (Rich Sagall) wrote:

You can make use of Get(CalculationRepetitionNumber) in a tooltip to
pick up the repetition number that the mouse is pointing at.

Dan Fretwell <dan (AT) owlsnet (DOT) co.uk> wrote:

I have tried that. Perhaps the problem is that article name field is not
a repeating field. What I need to do is use the number in repeating
field to match with a numberfield in a non-repeating field.


Layout 1
1 2 3 4 5 6 7 8 9 10 (a repeating field)

Layout 2 (two fields)
Number Article Name
1 Topic1
2 Topic2
. .
. .
10 Topic10


When I move the cursor over a number in layout 1 the corresponding
Article Name should appear in the tooltip.

Rich

OK Rich

Try the following. Construct a Value list "List" consisting of values
from the Article Name field show also the Number field sort by the
second (Number) field. This will ensure that the value list items are
in the order that you want. In your table define an unstored
calculation field List = ValueListItems(Get(Filename);"List"). I am
guessing that you have more than 10 article names and you are somehow
producing a "Top Ten". If that is the case then you only need the first
ten values of this field. So then define List =
LeftValues(ValueListItems(Get(Filename);"List");10 ). This must be
unstored if your article list is changing so cannot be global.

Now the tooltip:

MiddleValues(Table::List;Get(CalculationRepetition Number);1)

Table is just the name of the table where List resides. This produces
the Article name. If you want any more text or other calculations add
them in.