"fiaolle" <fiaolle@telia.com> wrote in message
<xr1Jg.14730$E02.5775@newsb.telia.net>:

How do you do this?

I think, if you drag'n'drop the whole primary key (the two fields)
from tbl_movies to tbl_moviecategories, you should only have to
ensure that both fields are listed for both tables, then hit the
enforce... thingie, and OK.

Or, if you just drag'n'drop one field, ensure you select both fields
for both tables in the lists in the edit relationships dialog before
hitting the enforce... thingie and OK.

Fia,

First, I'm a learner, not an expert and all following advice should be
viewed as such.

It looks like you have three tables, none of which have the same PK
identified. i.e. 1 table has 1 field for PK, 1 table has 2 fields for
PK and 1 table has 3 fields as PK. This seems to tell Access that
pk1=pk1a=pk1a1, nothing is really a usable uniqe identifier.

If you need to use more than one field as an identifier, you might try
joining the two fields into a third to creat the unique identifier.
I'm sure there is an easier way (There almost always is) but my book
doesn't cover it so you get my experience not neccessarily the best
answer.

looking at the info provided, I would link
tbl_Movies.movieID(autonumber) to
tbl_MovieCategories.movieID(number, long integer)

one is assigned and the other refers to the first.

tbl_MovieCategories looks like a pivot table and unless you need the
data available as such is redundant.  Should probably be part of a
query or report.

Hope this helps some,

Byron