Coul;d anyone explain what an intermediate relationship is? Im just starting
out and Im alittle confused?
Regards.
I suspect you mean an "indeterminate" - that is, "I cannot determine
what kind" - of relationship.
You will get this type of relationship if you join two tables on
fields which do not have a unique index in either table.
Each table should have a "Primary Key" field - by definition, this
field is unique within the table; normally you would link from this
field to a "foreign key" field of the same datatype in the second
table (use a Long Integer if the primary key is an autonumber). This
will give you the most common type of relationship, One to Many.
In certain RARE instances, you can join one table's Primary Key to a
second table's Primary Key, or to some other field which has an index
which you have defined to be unique (note that you CANNOT join to an
autonumber field in the second table); this gives you a One to One
join.
If you need a Many to Many join (and you will, they're very common)
you will need to create a third table related one to many to each of
your main tables. This table will have one record for each pair of
joined values in the main tables.
