Is there a way to program that a le (lotNo) is unique only if a different le (type) has a certain value? Or to let me know if it is the same based on certain criteria?

If you merely want to check if an element is unique based on the value in an another element (without worrying about other factors), you can use an if statement on the value in the other element and put a @IsUnique call or one of the "X" commands (XLookup, XResultSet, etc) inside the curly braces for the if-statement - to look up whther the current value is unique.

The unique formatting is available as a static property of an element. If you want it to be dynamic, you need to check if the value in the element is unique when your other element is set to "receipt". The @IsUnique call can check that at when the user leaves the element, but before they commit the form.

The first argument to @IsUnique is the element to check. In your case this would be "lotNo." The second argument is the value to check for. Since you want to check the value currently in lotNo, this could also be lotNo. If you test this on a form that already has a committed value, it will test as non-unique because @IsUnique was designed to test values before they get used so as to prevent the use of non-unique values being committed.

In the element exit event:

if(transaction = "receipt")
{
    if(@IsUnique(lotNo, lotNo) = 0)
    {
        @MsgBox("tsk tsk")
    }
}
 

This code could use a flag and maybe a NotifyForm command to prevent the record from being committed if the condition is not met. And, as I said before, you may want to revisit the condition if they go back and change "transaction".

You may want to consider using a subroutine, so that you can call that subroutine if either transacton or lotNo change.

The Cow wrote on Feb 6^th, 2012 at 6:17pm:

Interesting. I just tested this, and found that it does set a field to the unique state. But, you can't detect the unique state with @ReadOnly -- it just reports "0" (writable). Which is true, because it is writable. Though, it would be better if it reported "3".

EDIT: I also checked @Attribute, and that also reports "0".

Well, that explains it. Thanks Mark.

Not that I need it, but just curious...
Is there a way to check the state of UniqueFlag?

if (flag == 3 

Would you please explain what does "==" means in coding?  I do use that when I want to make blank record using @XResultSetSearch ( ) but I do not know what exactly it means. Thanks.

Thanks Carl.