I have a database of 35000 cards I keep on filemaker. There are some
improvements I would like to make. Here is one:

These are my fields:

Year
Card_Brand (this includes actual card brand and sub set groups)
Card #
Player Name
Currently own (checkbox)

I look at these most often in Table view

When I purchase a card, I look it up and check the 'Currently own'
checkbox. Once the checkbox is checked the record turns red (so I know
that I own that card).

What I would like to have happen is:
if I complete a set it turns blue
if I have 2 or less remaining to collect in the set it turns green

something along those lines.

Here is an example of what I have:

If I am looking up 2005 Topps Finest Refractor, what pops up is:

2005 /Topps Finest Refractor /25 /Emmitt Smith
2005 /Topps Finest Refractor /46 /Troy Aikman
2005 /Topps Finest Refractor /69 /Kelvin Williams
2005 /Topps Finest Refractor /72 /Charles Haley

If I own the card it is highlighted in red

If you have any ideas on how I can make this dream a reality let me know.

Thank you,
Steve









I currently can tell if I have a card in my collection by checking a
box and the line turns red.

On Thu, 20 Jan 2011 19:49:50 -0500, Steve Berebitsky
<sberebit (AT) gmail (DOT) com> wrote:

This solution assumes each set has a unique set #. If they don't it
should be easy enough to set up.

Then use some conditional formatting that compares the count of each
set # to a count of the checkboxes which are checked that have that
same set #. If they are equal than you have the complete set, if the
checkbox count is >= to the set # count -2 you would be within 2 of
completion.

Thank you for your help... I will give it a shot.

On 2011-01-20 21:15:39 -0500, Michael Myett
<michael.myettatadelphia.net@> said: