Dear All
table1 has list of names, date of birth and passport number.
table2 has list of items like beer, whisky and soft drink and price
The scenario is that the names in table1 will purchase few items in table2.
What I need to have is a report or a new table to show who has purchased what and how much to deduct from his salary.
For example: one person by name Charlie from table1 has purchased 3 whisky and 4 soft drinks. How to use enter this consumption against the names in table1. I do not want to add fields like beer, whisky and soft drink in table1.
Pls advice me best way to use these two tables and to make a report of items purchased and amount.
brgds/captgnvr