Forum Discussion
Solved
fixing a relationship
I have some related tables, and I'm trying to work out the best way to 'fix' a relationship issue. going from left to right, A site has many categories, and each category has many items. ...
I would stick with the 1st layout but use the CombinedName to join Categories to SiteItems.
ie.
Sites --> Categories --> SiteItems
If you still unable to create a many-to-one relationship between Categories and SiteItems, it is probably a data issue. (ie. SiteItems without a corresponding Category)
I hope this helps.
Thanks, It was a data issue as you suggested. Found some blank rows in the table.