hi

i have two combo boxes  'category' and 'capacity'

the data in  first combo box 'category' is as follows
category-A
category-B

the data in second combo box  'capacity' is as follows
200
300
400
500

the combo boxes take th values form the value list and not from any
table/query  and stores the data in to a table 'tblone' which has the
following three fields
sno  -- is a autono
category  - text data type
capacity - number data type

here i would like the
second combo box to show me 200 and 300 if i select the category-A in the
first combo
and
the second combo must show me 400 and 500 if i select the category-B in the
first combo

i am an access beginner

suggest me pls