It sounds like you are missing an intermediary link table ...
Create a table that has a Primary Key consisting of one to many relationship
of the primary key from your two tables.
You then have a many to many between your two tables, via the link table.
"Jacqueline" <Jacqu...@discussions.microsoft.com> wrote in message
news:136741AE-D3FA-4F5C...@microsoft.com...