Hello guys, I'm new here and completely frustrated 
Let me explain my situation:
I'm trying to build a form for a catering company I run. This catering company takes orders every day. With that, we input the orders (Currently in Excel) and print them out. From there we hand write all our procedures for the day.. (who cooks what, who organizes what etc) which opens up for a lot of human error. Which is why I'm trying to design our process in Access and have all the data that is input that day to then print out reports for each person.
An example: We get 3 orders that day. 1 order contains 3 baked lasagnas, 1 desert, and setups (plates and cups) the second order gets 1 Marsala, 2 deserts, setups, and drinks, and the 3rd order gets 1 salad, 1 chicken parmesan, 1 desert, setups and drinks.
We then each write what we do:
Front end- counts the setups, makes salads, and gets most deserts ready
Chef Assistant - does baked meals and preps stuff for the chef
Chef - Does marsala, prepares the chicken
So I need a report for each one. (but this isn't my problem yet, havn't gotten this far)
My Tables:
I currently have 4 Tables.
Reps (The customer)
Pk - ID
OrderInfo (Date / Time / Location / Etc)
PK - OrderInfoID
Orders (Products they are ordering)
PK - OrderInfoId
Food Items (The items they can order)
PK - ItemID
Relationships:
Reps.ID --> Orderinf
rderInfoID --> Orders.OrderInfoId
The Form:
I have 3 forms.
DailyOrders (parent of OrderInfo)
Order Info (parent of Orders)
Orders
I need the reps to be present in the DailyOrders form and be selected by a drop down. Upon selection it will show the information about the reps (their cc#, phone number, etc.. can't be changed here)
Then in the order info have the data inputed so it can represent their daily requirements.
Orders, what meals / deserts / etc they ordered.
Click save + new or Save + exit button to return to the switchboard.
So, my problem exists by making the active drop down menu that alters the other fields for that category and the person doing the orders can move to the next areas to fill in.
Attachments include my current DB (2003) and a screen shot of my relationships.
Ive read the following books thus far :
MS Access for Dummies
MS Access Bible
MS Access ALL-IN-One for Dummies
Step by Step MS Access
And asking everywhere for help. I'm not one to have someone do it for me, I need to learn this. If someoen can guide me I would greatly appreciate it.
AIM - Chadz777
MSN - Chadt777 at Hotmail.com
If you wish to contact me in person to speed things up I would greatly appreciate it.
Otherwise, Thanks in advance, and sorry for the long read!
Chad
Let me explain my situation:
I'm trying to build a form for a catering company I run. This catering company takes orders every day. With that, we input the orders (Currently in Excel) and print them out. From there we hand write all our procedures for the day.. (who cooks what, who organizes what etc) which opens up for a lot of human error. Which is why I'm trying to design our process in Access and have all the data that is input that day to then print out reports for each person.
An example: We get 3 orders that day. 1 order contains 3 baked lasagnas, 1 desert, and setups (plates and cups) the second order gets 1 Marsala, 2 deserts, setups, and drinks, and the 3rd order gets 1 salad, 1 chicken parmesan, 1 desert, setups and drinks.
We then each write what we do:
Front end- counts the setups, makes salads, and gets most deserts ready
Chef Assistant - does baked meals and preps stuff for the chef
Chef - Does marsala, prepares the chicken
So I need a report for each one. (but this isn't my problem yet, havn't gotten this far)
My Tables:
I currently have 4 Tables.
Reps (The customer)
Pk - ID
OrderInfo (Date / Time / Location / Etc)
PK - OrderInfoID
Orders (Products they are ordering)
PK - OrderInfoId
Food Items (The items they can order)
PK - ItemID
Relationships:
Reps.ID --> Orderinf
rderInfoID --> Orders.OrderInfoIdThe Form:
I have 3 forms.
DailyOrders (parent of OrderInfo)
Order Info (parent of Orders)
Orders
I need the reps to be present in the DailyOrders form and be selected by a drop down. Upon selection it will show the information about the reps (their cc#, phone number, etc.. can't be changed here)
Then in the order info have the data inputed so it can represent their daily requirements.
Orders, what meals / deserts / etc they ordered.
Click save + new or Save + exit button to return to the switchboard.
So, my problem exists by making the active drop down menu that alters the other fields for that category and the person doing the orders can move to the next areas to fill in.
Attachments include my current DB (2003) and a screen shot of my relationships.
Ive read the following books thus far :
MS Access for Dummies
MS Access Bible
MS Access ALL-IN-One for Dummies
Step by Step MS Access
And asking everywhere for help. I'm not one to have someone do it for me, I need to learn this. If someoen can guide me I would greatly appreciate it.
AIM - Chadz777
MSN - Chadt777 at Hotmail.com
If you wish to contact me in person to speed things up I would greatly appreciate it.
Otherwise, Thanks in advance, and sorry for the long read!
Chad
