Hi I am trying to create a restaurant's database. I have 2 main tables menu (food) and then another table for order.
I have built a relationship so that on the order data base there is a lookup box which accepts multiple values, and so I just click the items being ordered. However how can I make the lookup box accept different quantities e.g. if the order has 2 of the same item of coca cola.
Thanks for any ideas. Please tell me where to put any new fields etc.
I have had a few tries but no luck
Thanks in advance
I have built a relationship so that on the order data base there is a lookup box which accepts multiple values, and so I just click the items being ordered. However how can I make the lookup box accept different quantities e.g. if the order has 2 of the same item of coca cola.
Thanks for any ideas. Please tell me where to put any new fields etc.
I have had a few tries but no luck

Thanks in advance