Rayne
asked on
Query To pull all related data
Hello
There is DB that I just created.
Assumption -
Each nation has several states but each state will never be owned by several nations
Each state has several districts but each district cannot belong to several states
Each item can be sold to several districts and each district can have several items
How do I construct a form that that can fill in the order table keeping in mind the this relationship?
Thanks
DataB.accdb
There is DB that I just created.
Assumption -
Each nation has several states but each state will never be owned by several nations
Each state has several districts but each district cannot belong to several states
Each item can be sold to several districts and each district can have several items
How do I construct a form that that can fill in the order table keeping in mind the this relationship?
Thanks
DataB.accdb
ASKER
orderID ItemID Nation State District
1 i89 USA Colorado North East
1 i89 USA Colorado North East
ASKER
The order table will have the above attributes or columns….
ASKER
I just installed the northwind database…can someone be kind enough to direct me to a sub form (within the northwind DB) that might help me get going in this direction?
http://download.cnet.com/Access-2000-Tutorial-Northwind-Traders-Sample-Database/3000-2251_4-10742880.html
http://download.cnet.com/Access-2000-Tutorial-Northwind-Traders-Sample-Database/3000-2251_4-10742880.html
ASKER
Please check query 2 - is this is the optimal query way to represent all the components of the Orders table? Or I am doing something inefficient?
ASKER
The query and concept looks right.
What are you trying to get to?
What are you trying to get to?
ASKER
Hello Jim,
Thank you for confirming :)
Given the structure for my data - One thing if its possible to indicate - do you think just one form is enough to fill in the fields for these? or sequence of forms in this order?
(1) I need to create a form to fill (Nation + State + District) first ,
(2) then create another form for filling Item and (3) create another form for filling orders?
Does that make sense or I am thinking wrong?
R
Thank you for confirming :)
Given the structure for my data - One thing if its possible to indicate - do you think just one form is enough to fill in the fields for these? or sequence of forms in this order?
(1) I need to create a form to fill (Nation + State + District) first ,
(2) then create another form for filling Item and (3) create another form for filling orders?
Does that make sense or I am thinking wrong?
R
ASKER
Goal - users should only have forms to fill in the different table entities in the DB. They should not be able to use any other means to fill in these tables, only via forms
So my thing - i need to understand (1) what forms do i need create to fill in all tables and (2) how to sub form one form on the main form if possible? - for the ORDERs table
So my thing - i need to understand (1) what forms do i need create to fill in all tables and (2) how to sub form one form on the main form if possible? - for the ORDERs table
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Hello Jim,
I can't thank you enough for sharing this gold idea :) and offering me a wake up call (i was sleeping :(
Your help really gave me a good idea of what I need to think about and stress on. Thank you Sire for your kindness, greatly appreciate it
Respect
R
I can't thank you enough for sharing this gold idea :) and offering me a wake up call (i was sleeping :(
Your help really gave me a good idea of what I need to think about and stress on. Thank you Sire for your kindness, greatly appreciate it
Respect
R
ASKER
Thank you again Jim :), this is a eye opener for a newbie, thank you
ASKER