FMPRO-L Archives

January 2011, Week 4

FMPRO-L@LISTSERV.DARTMOUTH.EDU

Options: Use Monospaced Font
Show Text Part by Default
Show All Mail Headers

Message: [<< First] [< Prev] [Next >] [Last >>]
Topic: [<< First] [< Prev] [Next >] [Last >>]
Author: [<< First] [< Prev] [Next >] [Last >>]

Print Reply
Subject:
From:
Tom Elliott <[log in to unmask]>
Reply To:
FileMaker Pro Discussions <[log in to unmask]>
Date:
Sat, 22 Jan 2011 11:02:14 +0000
Content-Type:
text/plain
Parts/Attachments:
text/plain (35 lines)
Richard

Solution Part the 1st:

As Mike has said: build a milti-value key using GetNthRecord()

OR

create a self-join Cartesian relationship:

<layoutTO>::<anyField> x <newTO>::<anyField>

base your portal on the new TO and filter the portal with the formula:

<newTO>::danSeq > Get ( RecordNumber ) - 10
and
<newTO>::danSeq < Get ( RecordNumber ) + 10

(if you have, or will ever have, a vast number of records screen updating may prove to me unacceptably slow)


Solution Part the 2nd:

I'm assuming that you already have an invisible button in the portal; make sure it's behind everything else in the portal and Conditionally Format its fill colour with the formula:

<layoutTO::danSeq = <portalTO>::danSeq

If you haven't already got a button, you could use a text box containing a single space - or if you have a single field in the portal, you could Conditionally Format that.

[it appears that you are attempting to use a calculated field to provide the highlight rather than native Conditional Formatting]


cheers

Tom

ATOM RSS1 RSS2