Awesome. Thanks again Phil. I made a new field (c_In) in status: if( isempty(checkindate), "Out", "In"). I then used calcIsIn in products to find last(c_In).
There are several products that have no value due to not having been checked out. I attempted to do: If( IsEmpty(Count(Status::id)); "IN"; Last(Status::calcIsIn))
This does not give a value to the products that have no records though. Any clue?
Be sure to clear the "do not evaluate if all referenced fields are empty" check box that is found in the specify calculaton dialog.
Thanks again for the quick reply. I didn't even think about the "Do not evaluate..." option. I changed this and it still does not provide the correct calculation. I created a field that just has IsEmpty(Count(Status::id)) and it returns "0" for all records, including ones that have not been checked out and ones that have.
I then removed "isEmpty". IsEmpty(Count(Status::id) is now Count(Status::Id). It seems to work. Is there any reason for this? I do not know why "IsEmpty" was not functioning right. I was following FileMaker help articles to get to this point.
EDIT: Cancel that, it does not work without the "IsEmpty". I used "Count(Status::id)" and it displayed "0's" and I thought it was fixed but adding the if statement back does not result in any value.
EDIT2: I removed the count part. The formula, in Products is now: If(IsEmpty(Status::id); "IN"; Last(Status::calcIsIn)). Seems to be working. Is this wrong?
Looks right, but I can't be 100% sure just from the limited understanding that I have of your database at this point.