We have an Inventory table that, of course, holds our current inventory. We also have an Auctions table that stores all of our eBay auction data for inventory that we have posted.

My goal here is to highlight the ItemNumber of any item in Inventory (list view) that needs an auction posted.

Any item could have a bunch of auction records created for it. Auction records have a status field with values: Current, Winner, Loser.

I know how to use the TextColor function to change the color of a field's text based on an If/Then, for instance. But what I need is a calc. field that will be a 1 or 0 based on whether or not there are any current auctions for that item. If there are current records set NeedsAuctionPosted to a 0. If there are not any current auctions set NeedsAuctionPosted to a 1. Then my text color could look at NeedsAuctionPosted to decide whether to change the font color not.

Any information I can get on how to create a field that can search auctions records with the item's ItemNumber and set another field to 1 or 0 based on whether or not any of the current auction records were Current or not would be greatly appreciated.

Of course, if there's a better way to do this all together I'd love to hear that as well. Thanks!

You can do this with two calculation fields:

A calculation field in the Auctions table, that returns 1 if the auction is current (this could be based on the status field, or directly on expiry date - if there is one).

Then, in the Inventory table, define a calculation field =

not Sum ( Auctions::cCurrent )

For both fields, set the result type to Number.

Yup, that did it. Thanks a million!!!

Im not sure if you can help, but I'm attempting to do something similar. Depending on the status of a job, a status field changes. I recently made a new post; is there anyway you could help me with the textcolor command?

http://www.filemaker.com/help/FunctionsRef-388.html