Novice Needs help With Validation!

[JSylvia007]

I have 2 fields in a table. Basically I need:

if(Value in Field1 in any other record = Value for Field1 in new record) AND (DATE in Record = Date in new record) then disallow the creation of the new record. Please help me. I'm not that familiar with FileMaker.

~Jake

[RalphL]

This is a little tricky and I haven't had to do it in FMP 7 yet. Start by making a calculated text field = Field 1 & " " & Get asText(Date). Make a self-relationship of this new field to itself. You need to validate both fields by calculation. I think it is Count(Self::Field 1) for for Field 1. It may be Count(Self::Field1) = 0.

After you get it working make the validation strict. You may also want to use a custom message.

[JSylvia007]

Thanks for the reply! I'll give it a shot!

~Jake