With vfp6 you could create a rule for a field on a table:
ALTER TABLE (lcfilename) ALTER COLUMN &lcFieldName SET CHECK &lcFieldCheck
followed by an index command:
ALTER TABLE (lcfilename) ALTER COLUMN &lcFieldAndDataType UNIQUE
With vfp7 you must make the index first or you will lose the rule? Anyone else notice this?
Dr. Ken A. McGinnis
Healthcare software design