save a entry in database for the items in list

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.

Hi Dr. Akash Rajpal,

See my Excel database tutorial at http://www.edferrero.com/DataTutor01.aspx

Ed Ferrero
Microsoft Excel MVP
http://www.edferrero.com

>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.