Event item sales

D

Dan

I am creating a database based on Event Driven Item Sales. With the purpose
of tracking daily menu item sales.

the revenue table is to track the source of the revenue:money, visa,
mastercard, taxes etc...

I have 4 main tables:
tblevent tblitems tblrevenue
eventID itemID revenueid
event price rtype
eventdate active (y/n) debitcode
price
and a junction table
tblitemsales
itemsalesID
eventID
ItemID
sold

what is the best way to build the form? create a query on all 3 tables and
base the form on the query?

I have approx 35 menu items which I need to display in a continuous form, so
when the person enters sales for that event, they will see all the event
info, followed by a list of the menu items. I would also like the form to
show calculations for dollar values. so basically:

item sold price sales tax
service fee total
hotdog 5 $3 $15 $2 $2
$19

I am not sure how to get all items to list in a continuous form. I would
also need a form to list the revenue source, so I can balance item sales to
revenue

thanks
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top