Hi,

I've spent a while on this and managed to get my poor head
spinning.....maybe someone can put me straight?

I have a Filemaker database showing a number of bank accounts.
Information such as names of account, date opened, date closed, balance
and such like is included for entries as appropriate.

Many of the bank accounts are closed as interest rates become less
attractive. After a number of years I now have a huge list that makes
reading the document troublesome. I want to keep all the information for
tax return/reference purposes but would like to show the list entries as
'greyed out' once the account is closed so that it is clearer. Can this
be done with a script?

Might it be better to create a separate layout that excludes closed
accounts? If so, how would I do that?

It's FMP 11.

Thanks.

Jim

In article <4e359200$0$1683$c3e8da3$33a0879d (AT) news (DOT) astraweb.com>,
Jim <madonspam (AT) gmail (DOT) com> wrote:

A simple approach is to add a field to indicate if an account is open,
then do a find to show only the open accounts.

Tell us a bit more about the structure of your database and maybe we'll
be better able to offer advice.

--
Bill Collins

Bill explained on 1/08/2011 :
Along with a field to indicate closed or not, Conditional Formatting
could be used to grey parts of the list if these records need to be in
the same Find.