Event item sales

[Guest]

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

 

[Guest]

let me rephrase, how do I make a continuous subform?