I am guessing that you meant to type indeterminate not
intermediate. Going on that assumption I would advise
youtrying to make, the key, and the tables. Make sure
that it truly is a one to Many Because every indication
that I to make sure that all of your Tables and Keys are
correct. The only time I know Access to say there is an
indeterminate relationship is when there is an
indeterminate relationship. This says to me that perhaps
there is an issue with your tables or keys. I am also
making the assumtion that you are trying to do this in the
relationships window and not some other way. My advice is
to check and double check the relationship that you are am
getting from your message tells me that Access doesn't yet
recognize it as a one to many relationship which could be
for lots of reasons.
Taylor