I want to create these fields:
coloumn a: a drop down list of names
column b: drop down list of dates
column c: drop down list of some numbers and alphabets

I want to corelate all these three columns for the item selected.
eg: if i select name "john" from column a and "1/1/6" from column b and
select "4" from coumn c then i need a report generated which will mention
"john" on "1/1/6" had "4" units and "john" from "1/1/6" to "31/1/6" had "??
total units"

Can some one help create the same.