Need help to start a simple form

[mattmurdock]

Hey guys, I'm really trying to learn Access but just started and stuck. I feel this is really simple but unfortunetly I don't know where to turn except to you wonderful people.



These are the tables I have- Item size (ex: 12oz, 16oz, 24oz), Item Price (ex: $70, $90, $120), and Upcharge (ex: $5, $6, $8).

The final result I want is a form that can have the user insert the Item name, Item description and Item PIN . Then select the Item size (which will auto fill the Item Price) and select the Upcharge. Lastly I would like a table at the bottom of the form that combines all these features and gives a total amount (which is price+upcharge+ a 1% discount). What/where/how info on queries would be greatly appreciated.

Any help on where to start or a step by step of a part or all of the process would be greatly appreciated. Like I said, I'm trying to learn but don't know how to really start.

Thanks in advance

[orange]

Can you tell us in plain English what exactly your application does/or should do?
Can you post a jpg of your tables and relationships?
In order to get your forms and queries to work the way you want, you have to make sure your tables and relationships support "your business".
So database structure first, then forms.

[June7]

What is purpose of this form - customer order entry or are you building table of products?

If this is order, need another table at least, maybe 2.

tblOrders
ID (primary key)
CustomerID (foreign key)
OrderDate

tblOrderDetails
OrderID (foreign key)
ItemPIN (foreign key)
Size
Price (how can this be automatically selected if there is no relationship to the item?)
Upcharge