Beginners help

[jw7777]

I am very new to access but I believe I am a quick learner. I am looking to create a simple database for a catering company. It would consist of a list of all customers who have ordered through our catering. It would also have the ability to see customers order history with us by clicking/selecting on any particular customer.

Would someone be able to point me in the right direction as to how I would start this?

Thanks


JW

[ranman256]

you meed 2 tables, tClient, tClientOrder

tClient
---------
clientID (autonum)
Name
address
etc.

tClientOrder
----------
OrderID (autonum)
ClientID (long) (the key id from master table tClients)
EventDate
EventPlace
Cost
etc

In RELATIONSHIPS , you must make a parent child relation tClients.ClientID --> tClientOrder.ClientID

[Ternick]

There is an Invoice Template in access that I think would do what you want. Just have to change the items to what you do. If you have a hard time finding it let me know with your e-mail via pm and I'll send it over.

[ItsMe]

I do not know that what you are describing is simple or even a small database. Any time you are managing Customers and Orders, you are going to have some complex relations.

You might want to look for some tutorials. Here are some
https://www.accessforums.net/tutoria...tml#post236569

And
http://www.rogersaccesslibrary.com/forum/forum46.html