Hi everybody!
There are two fields in a table that I don't want for any new record
to hold the same entries that an existing one carries. They would only
have the some entry in either one of these two fields.
That is, if an existing record holds the values, fieldA = 2 and fieldB
= 5, then a new record would be only allowed to carry the values,
fieldA = 2 or fieldB = 5, but not fieldA = 2 and fieldB = 5 as the
existing record holds.
One way to overcome this problem is to create a composite primary key
including those two fields, but I'd like to avoid it.
Is there any other way to solve this problem?
Thanks,
Theodore
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/ms_access/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
