I am creating a base for a bar which has registered members coming in to order drinks every evening. I have created a table for recording the various members’ tabs. This tab has to record the details of each member’s drinks consumed/ordered on that particular day.
My challenge now is effectively recording the quantity of the drinks. Especially when a member orders the same drink more than once. The drinks are listed on a separate table which is connected to the ‘Tab’ table through a link field. Now when a particular drink is selected once, it cannot be selected again. Also, in the event that the buyer orders more than one type of drink, recording the quantity bought for each type is proving hard to do.
Any thoughts as to how to go about it?