I have several tables linked together but some of the relationships
are being displayed as 'Indeterminate' in relationships view. What
does this mean? How can I get around it? Is it possible to force a
relationship such as one-to-one?
Many thanks for any help.
Relationships are one to one, one to many, or indeterminate based on
the indexes on the joining fields.
If the tables are joined on fields which have a unique index in both
tables, the relationship will be one to one (and note that such
relationships are very rarely actually needed; if it's a real one to
one relationship you can usually just put all the fields in one table
in the first place. Subclassing is one case where one to one
relationships can be useful).
If one table has a unique index, and the other table doesn't, it's a
typical one to many relationship.
If neither table has a unique index on the joining field, the
relationship is indeterminate, since Access cannot determine anything
about how many records in one table might be linked to records in the
other. Such relationships cannot be enforced and usually suggest that
you need to rethink how your tables are structured, or whether this is
a real relationship at all.
