thanks for the quick reply
but i don't understand.
can you dumb it down for me please ?
i have two tables, stores and items.Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=10231Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=10231
stores has a primary key which is to be the foreign key in the items
when i drag the storepk from the items table to the stores table in the
relationship it doesnt change it to a foreign key and doesn't
reconginze it as a unique index.
i haven't used access in 3 years or more i basicaly remember nothing,
all help is appreciated