Restaurant System

[abcman]

Hi there,

I am trying to make a restaurant system. my problem is that I want to make buttons like command buttons with sandwich names for example and when I click one it automatically adds its value like "Steak" to a list box or to a list in the same form where I can add another and another and then I can easily print this list as an invoice.

Any ideas and hope it will be simple without the need to program in VBA as I am not much good in that. Thanks in advance.

 

[The_Doc_Man]

Sounds to me like you need to have a parent/child table setup. One invoice will have many line items. You want to open a new invoice from your main form, then your buttons need to add entries to your line-item table.

It should be possible to write a bunch of macros to do this but it would be more accurate and more effective (and easier to debug) to learn enough VBA to do what you wanted.

One thing to consider: If your invoice number is on-screen, you can append a record based on the visible invoice number and the code or name for the item in question. You could then add line-item name and cost to the line-item table, but keep a running total of the cost on the main screen. Always remember to tell the computer how to give you the answers you needed, such as how much this is going to cost the customer.

 

[abcman]

Excellent. Thanks but how do I make a button that adds to my subform. Do I assign a value to it or what.

2nd. Is there an example made where I can look at and maybe learn ?. Thanks.