How do I create a form in Access that auto-fills information?

Question

I am trying to create a form in access for my Pizza Place. I have tables in the same database that have my customers, my employees, and my different products.

My question is, can I make an order form that will automatically put all of my existing customers information when I put in their phone number on record.
I also want to be able to put in an employee ID in the same form that will bring up which employee is taking the order, and automatically fill the name and price of a product when I put a shorthanded version of the name in a box.

I have been racking my brain trying to figure this out, and I can't find anything online that can help me.

Please let me know if this is even possible to do in access, and if so how can it be done.

Answer 1

While you could do what you are suggesting, it's not the standard way it's done. The standard way is to relate the tables together, and just use combo boxes.... e.g.



tblCustomers

CustomerID

CustomerName

CustomerTelephoneNumber



tblEmployees

EmployeeID

EmployeeName

EmployeeTelephoneNumber



tblProducts

ProductID

CurrentPrice



tblPurchase

PurchaseID

PurchaseDate

EmployeeID

CustomerID



tblPurchaseDetails

PurchaseID

ProductID

Count

CurrentPrice (this needs to copy current price of product

Answer 2

The answer is yes, it's possible.



However, Access is not the best idea to build your business around. I would search google for some free or cheap restaurant order taking software.

Answer 3

It's a classic example of many-to-many relationship, you can find it in any entry-level book on relational databases. So, the answer is yes, you need a third table that makes it possible to handle many-to-many relationship