ehazel2001
New member
- Local time
- Today, 05:29
- Joined
- Oct 30, 2008
- Messages
- 3
Ok, so I have this database that I've created to process catering orders for a restaurant. These are my tables:
Customer
ID (PK)
Customer Name
Address
Telephone
Equipment
ID
Equipment Name
Price
Menu Item
ID
Menu Item Name
Specifications
Type of Food
Staff
ID
Staff name
Job
Telephone
Email
NEW JOB
ID
Customer Name
Menu Item Name
Staff name
Event Date
Event Time
Estimated Food Cost
Subbed Items
Notes
Number of Guests
Paid?
Directions to Event
Estimated Labor Cost
Estimated Rental Cost
Estimated Beverage Cost
Event Location
Final Food Cost
Final Labor Cost
Final Rental Cost
Final Beer
Final Wine
Final Liquor
CandO Notes
Date Paid
Method of Payment
Equipment Details
ID
Job ID
Equipment Name
Price
Quantity
I have created a form called New Job which has the following fields:
Job ID
Customer Name
Event Location
Number of Guests
Menu Item Name (Multi-Value Lookup)
Staff (Multi-Value Lookup)
Event Date
Event Time
Subbed Items
Notes
Directions to Event
Estimated Food Cost
Estimated Labor Cost
Estimated Rental Cost
Estimated Beverages
Estimated Total - This is calculated within the form & not an actual field anywhere
What I would like to do is insert a subform so that pieces of equipment can be "ordered" for each New Job. I created the Equipment Details table so that there can be a many to many relationship between Job ID & Job ID and Equipment Name & Equipment Name, the problem that I'm having is that I can create new records which match up to the Job ID that is currently on the form, and I can get a drop-down list of the Equipment Names that are stored in Equipment, what I'm not getting is the price of the Equipment as it is related to the name in the record of the Equipment table...is this making sense??? I would like to be able to select a piece of equipment and have the price show up in the subform so I can specify a quantity for each piece and then give an extended price...which will total into the Estimated Rental Cost field already on the form. I can upload a copy of the database if this is helpful...
Customer
ID (PK)
Customer Name
Address
Telephone
Equipment
ID
Equipment Name
Price
Menu Item
ID
Menu Item Name
Specifications
Type of Food
Staff
ID
Staff name
Job
Telephone
NEW JOB
ID
Customer Name
Menu Item Name
Staff name
Event Date
Event Time
Estimated Food Cost
Subbed Items
Notes
Number of Guests
Paid?
Directions to Event
Estimated Labor Cost
Estimated Rental Cost
Estimated Beverage Cost
Event Location
Final Food Cost
Final Labor Cost
Final Rental Cost
Final Beer
Final Wine
Final Liquor
CandO Notes
Date Paid
Method of Payment
Equipment Details
ID
Job ID
Equipment Name
Price
Quantity
I have created a form called New Job which has the following fields:
Job ID
Customer Name
Event Location
Number of Guests
Menu Item Name (Multi-Value Lookup)
Staff (Multi-Value Lookup)
Event Date
Event Time
Subbed Items
Notes
Directions to Event
Estimated Food Cost
Estimated Labor Cost
Estimated Rental Cost
Estimated Beverages
Estimated Total - This is calculated within the form & not an actual field anywhere
What I would like to do is insert a subform so that pieces of equipment can be "ordered" for each New Job. I created the Equipment Details table so that there can be a many to many relationship between Job ID & Job ID and Equipment Name & Equipment Name, the problem that I'm having is that I can create new records which match up to the Job ID that is currently on the form, and I can get a drop-down list of the Equipment Names that are stored in Equipment, what I'm not getting is the price of the Equipment as it is related to the name in the record of the Equipment table...is this making sense??? I would like to be able to select a piece of equipment and have the price show up in the subform so I can specify a quantity for each piece and then give an extended price...which will total into the Estimated Rental Cost field already on the form. I can upload a copy of the database if this is helpful...
