pass field to form and calculate 1

[downandout]

I am very,very much a beginner this is what I have:
table1 for products(code,name,unit cost,etc)
table2 for sales(code,dates,amounts,etc)
What I would like to do:use a form to enter each sale(code,weight,cost etc) , having got unit costs from table1 (using a query?),calculated the sale and write this as a record to table2.
I know how create forms,queries,tables, what relationships and subforms are , do not know sql.
If I use a query to get the unit cost , how do I pass this to the form? and where do I do the calculation ? How do I make the form always add a new record to table2.

 

[DoogieB]

Dear Downandout,
It would really be a lengthy response to tell you how to do all of this. Access is one of those things you have to roll up your sleeves and jump in. You're off to a good start. I recommend looking closely at the Northwind.mdb sample database that came with your license. Check the help files for its location. Also, consider a good simple book for some of this. I used the Dummies book when Access 95 came out and actually found it very helpful. I also like Wrox Press books very much.

Here's a basic rundown of what you're doing (as I understand it)
Pull up a customer (by combo box on a main parent form)
Enter sales items onto a sub form
Have the calculated costs fill in.
Save the data to a table (Invoices?) which is linked by CustomerID.

Does that sound about right? Keep looking for examples of things that do the same kind of function and pick them appart.
DoogieB