P
Peter
I have two tables, Genus and Species, in a taxonomic database, joined
in a one to many relationship. When the use enters new data, I need to
prevent duplicates of the two names as a whole, but permit duplicates
in the tables individually. That is, I can allow Homo (Genus) Sapiens
(Species), Homo Asinus, Homo Neanderthalis - duplicates in the Genus
table. I can also allow Homo Sapiens, Felix Sapiens, Canis Sapiens -
duplicates in the Species table. But I cannot allow Homo Sapiens to
occur more than once.
Is there any way to build constraints in indices, relationships or any
other "automatic" machinery? I know how to do it in code attached to a
form, no problem, but I prefer to use Access's built-in functionality
whenever possible. However, I don't know of any way to enforce this
across two tables. Am I missing something obvious?
in a one to many relationship. When the use enters new data, I need to
prevent duplicates of the two names as a whole, but permit duplicates
in the tables individually. That is, I can allow Homo (Genus) Sapiens
(Species), Homo Asinus, Homo Neanderthalis - duplicates in the Genus
table. I can also allow Homo Sapiens, Felix Sapiens, Canis Sapiens -
duplicates in the Species table. But I cannot allow Homo Sapiens to
occur more than once.
Is there any way to build constraints in indices, relationships or any
other "automatic" machinery? I know how to do it in code attached to a
form, no problem, but I prefer to use Access's built-in functionality
whenever possible. However, I don't know of any way to enforce this
across two tables. Am I missing something obvious?