This is is reference to the previous question:
Each item can belong to several distribution pipelines (item 11234 can be sold to grocery, government)
Each distribution pipeline can have several items (in grocery pipeline, there are 10000 items sold)
Each distribution pipeline can have several tiers (grocery pipeline has 4 tiered cost – tier1,tier2,tier3,tier4 while government pipeline only has 2 tiered cost ( tier1,tier2)
Each tier can be contained in several distribution pipelines (grocery pipeline and government, both have tier1 bracket for items)
I kept LCMConsulting’s advice and then further study my data. I came with the relationship in the attached access file.
The new thing – an item can be sold to many countries and each country can have several items – so it’s a many to many – hence I created a connecting table between item and country – itemCountryline and now….
I tried joining in itemcountryline to another table DistPipeTier…Can you please check if my making of relationship makes any sense?