Rayne
asked on
Follow up Relate
Hello
This is is reference to the previous question:
https://www.experts-exchange.com/questions/28286514/Access-relate-question.html
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?
Thank you
sampleSome.accdb
This is is reference to the previous question:
https://www.experts-exchange.com/questions/28286514/Access-relate-question.html
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?
Thank you
sampleSome.accdb
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thank you both so much for your priceless advices. I will come back with more questions and data :)
ASKER
Hello All,
I am back with more info….
An item can belong to several countries and each country can have several items –
There is price categories per item- an item can belong to several different price level for the SAME distribution pipeline
Refer to previous post for more relationship info….
Now the easy part is that - the need is for ONLY ONE report out of this database – which lays all the different info set in one line like the attached xlsx file.
So how can I make the DB scalable for storing new data (also and keeping in mind the relationships) and so that the data is stored in the most efficient way, but when I need the report out of it – I can get that all in one row
Please assist
Thank you
sampleSome2.accdb
data-look-this.xlsx
I am back with more info….
An item can belong to several countries and each country can have several items –
There is price categories per item- an item can belong to several different price level for the SAME distribution pipeline
Refer to previous post for more relationship info….
Now the easy part is that - the need is for ONLY ONE report out of this database – which lays all the different info set in one line like the attached xlsx file.
So how can I make the DB scalable for storing new data (also and keeping in mind the relationships) and so that the data is stored in the most efficient way, but when I need the report out of it – I can get that all in one row
Please assist
Thank you
sampleSome2.accdb
data-look-this.xlsx
ASKER
Hello All,
i have posted the follow up here
https://www.experts-exchange.com/questions/28319396/follow-up-Relate-2.html
i have posted the follow up here
https://www.experts-exchange.com/questions/28319396/follow-up-Relate-2.html
ASKER
We can scrap some of the tables if that doesnt make any sense - I just want to make sure that the relationship is somehow reflected...for data storage and scaliblity
ASKER
Is my relationship design makes sense?
Efficient enough for creating good forms and filling up the tables?