I would like to have a status windows that shows if a statment has already been paid. I have one file with the statement and the status windows and another file that contains an associtated record based on its serialnum. What i need is to have something like (if serial number exist in file paidcommison then show COMPLETED otherwise show UNCOMPLETE)

possible?

tony

Hi Nightshift,

I would use a Case Statement.

If I'm following you correctly, you have two files A and B and you want to see in A when a Serial Number exist in B. I would do this through a simple calculation and a relationship.

It is less confusing to create a calculation in the file that the information is based on, in this case a field called SerialNumber, so I would create this calculation in File B.

Case(IsEmpty(SerialNumber), "Uncompleted", "Completed")

In order to see this in File A, you need to create a relationship from File A to File B, I would use one based on Client ID, and then place a new field on a Layout in File A and pipe through using the relationship. Keep in mind that you could create this calculation in File A using the relationship too.

HTH

Lee

I would also use Case but with these definition and relationships.

Relationship SerialNum::SerialNum

cStatus = Case(isValid relationship(your relationship), Completed,Uncompleted)

or simply use a lookup field Status from the other file cStatus field (calc) = Case(Amount due*>0, Uncompleted, Complete)*

* or any other field to have the result Complete, Uncomplete