G
Gary
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
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