Food delivery, looking for a design being able to take orders and track customers

[mrmole]

Dear friends,

I am a at most a beginner in access and the only experience I had was in one class in college.



I am now a restaurant owner and willing to create a database design for my food delivery service. We are delivering lunch boxes. I would like to make a database in such a way that would be able to track customers trends. For example, I will have a Customer table, order table, products table and sale rep table. Products would be about 12 different kind of lunch boxes (pork with rice, beef with vegetables etc.)

My customers are usually offices where they order many products for lunch.

My goal is not only to track customers but also to create a form design that would allow the receptionist (lady taking order) to take orders through a form. The inputs will be updated on each table.

I am now almost done with creating the tables and got stuck at whether I should have a orders detail table or just order table.
Please help me point in the right direction.

thanks!

[pbaldy]

Presuming an order could consist of multiple products, you'd want both.

[mrmole]

Presuming an order could consist of multiple products, you'd want both.

Great. thanks.

I am looking also to create a form, where the receptionist can take order and have a print current form with information required such as:

Customer data from customer table
Order date
Products ordered, price of each product, quantity, total quantity and amount.

Am mostly stuck at how to make such calculation in a form.

[JeroenMioch]

Great. thanks.

I am looking also to create a form, where the receptionist can take order and have a print current form with information required such as:

Customer data from customer table
Order date
Products ordered, price of each product, quantity, total quantity and amount.

Am mostly stuck at how to make such calculation in a form.

I have such a database at work, If i get around to it today i can give you the codes to make these calculations, allthough you can find them all over the web.
Look at the thread below to make customers appear on your form by entering their surname (or part of the SurName) in an unbound textfield for example, it might help you.
https://www.accessforums.net/program...tml#post132282
If you add line of code for FirstName, Zipcode, adress you can combine your search.
Its just copy/past stuff, no rocket sience

[mrmole]

I have such a database at work, If i get around to it today i can give you the codes to make these calculations, allthough you can find them all over the web.
Look at the thread below to make customers appear on your form by entering their surname (or part of the SurName) in an unbound textfield for example, it might help you.
https://www.accessforums.net/program...tml#post132282
If you add line of code for FirstName, Zipcode, adress you can combine your search.
Its just copy/past stuff, no rocket sience

I am using access 2010 therefore calculating 2 fields in a table is already automated by field type "Calculated" that you can select in field type box, however I am trying to calculate several fields on a form is the problem. If you could get to your database and give me a hint it would be great thanks!

[orange]

There are existing data models that may be useful at databaseanswers.org
You will have to adjust for your custom application, but these should give you some ideas.

http://www.databaseanswers.org/data_...ucts/index.htm
http://www.databaseanswers.org/data_...ders/index.htm