How to get various purchased amount made by persons

  • Thread starter Thread starter CAPTGNVR
  • Start date Start date
C

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
 
Use a form and subform. Form for names, no lookup, just scroll. Subform for
items, combo to select item, and quanity.

Set one-to-many relationship from name to 3rd table selecting Referential
Integerity and Cascade Update. Do same for Items table.

Set Master/Child links using primary key from name/items tables.

Scroll to name and select item in subform.
 
Back
Top