Access Coursework Help

[Hidi22]

I am creating a database for my A levels, I'm struggling to create the database. I am doing a stock system, in my purchase form I want my user to be able to select a food type and then be able to type in the quantity. From this I am trying to add a table that shows what the user has selected and the amount so that a total can occur.

[orange]

what have you done so far? tell us about your tables and relationships.
Have you done your analysis?
see this https://www.youtube.com/watch?v=9HRmSRR29fY

[June7]

Review http://allenbrowne.com/AppInventory.html

[Hidi22]

So far I have a form that's called 'Foods'. In this form I have the food type, the food price for each food and the quantity. I want a user to be able to select a food and for the price to come up according to the food, I would then like the price to alter according to the quantity selected. When the user has decided what they want I would want them to press the submit button to produce an invoice as a report. Could I get your personal email so I could send my work to you? It would make sense if I sent it to you as you can see the relationships as well.

[June7]

Save quantity and save price (but only if price is subject to change and you don't want existing records impacted by future revisions of price). Requires code (macro or VBA) to save the price. Then calculate the extended cost (quantity * price) in query when needed but do not need to save this calculated value.

No, I do not provide my email. You can attach db to post. Follow instructions at bottom of my post.