What's the best way to enforce field uniqueness when the field is allowed to be null? This should work whether data is being entered manually or by FileMan APIs (internal value which means input transform isn't useable). I'm looking for the behavior of a key index but that allows for null entries. The field is not a .01 field.

I also need to be able to screen the entry for the field and only accept those that are in a "pick list".

I was thinking about using an xref but I wasn't sure when/if I could safely delete the field's value from within an xref fire (if the field value is not unique or not in the pick list then it needs to be deleted).


-------------------------------------------------------
This SF.Net email is sponsored by xPML, a groundbreaking scripting language
that extends applications into web and mobile media. Attend the live webcast
and join the prime developer group breaking into this new coding territory!
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&dat=121642
_______________________________________________
Hardhats-members mailing list
Hardhats-members@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/hardhats-members

Reply via email to