How to get names, total of 20 items purchased?

[captgnvr]

Dear All

Thanks to this forum I have made some headway. Again I am stuck.

table1 with 50 names and staff code.

table2 with 100 items, price and stock.

With the forum guide managed to make a table3 with one field as lookup field to enter names, and items.

What is required is

1. an input form where, you select a name in combo box with all the items exhibited plus text field to enter the quantity purchased.

2. once all the quantities for the items purchased is entered against all the names, to make a report to show all the names and the total amount against their names.

3. at least give some links so that I can read and figure out.



Please help.

brgds/captgnvr

[captgnvr]

Dear All
Pls respond as I have been eagerly waiting for some guidance. I know it is too basic to ask and I do not have any books here with me to read and do. I have used access only with one table but unable to do using two tables -one with names and another with purchase items and link the two to get purchases made against the names.