Relationship change to one to one

G

Guest

I have a many to many table relationship problem with three tables. The
relationship of one side of the one to many has changed for some reason to
one to one. I can not get it to revert back to the one to many previously
displayed. I imagine in my learning process I have changed something that is
preventing this.

tblProducts
ProductId Pk
ProductDescrip
tblProductComponents
ProductId CPk
ComponentId CPk
ComponetQuant
tblComponents
ComponentId Pk
ComponentDescription
SupplierId
Units
ComponentCost
ProductCategoryId

The relationship between ComponentId in tblComponents indicates one to one
with ComponentId in tblProductComponents. It should be a one to many. Can
anyone help me understand what may be causing this.

thank you for your assistance
Gary
 
G

Guest

When you click on menu TOOLS - Relationships and try to change the relation
do you get an error message? If so, what is it?
 
G

Guest

No errors Karl, I finally deleted the join table and rebuilt it. The
relationship is one-to-many now. I suppose I corrupted a relationship.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Many to Many Form design 1
Cannot create one to many relationship 6
Design questions 17
Report Issue - one-to-many table relationship 1
no matching record on the "one" side in one-to-many relationship 1
One-to-one relationship 2
One to Many Relationship 2
cannot change relationship to one to many 11

Top