sincronized combo box

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

.

Relevant Pages

  • Re: Just saw Cars on Blu-Ray... now *THIS* is what high-definition should look like!
    ... there's a larger capacity disc.>> ... certain number of baseballs. ... Let's say you have a vehicle that's ... storing boxes of baseballs. ...
    (alt.games.video.xbox)
  • Re: integer or long overflow...
    ... > When you increase the number contained within an integer or long data type ... > beyond its capacity, what happens? ... a 2's compliment architecture (as most C++ ... number and keeps "increasing" - becoming less negative, headed towards zero. ...
    (comp.lang.cpp)
  • Re: 5.25" floppies for sale
    ... were 1.2 Mbyte but it doesn't actually state the capacity on the ... All the boxes I have are sealed so reluctant to open any unless ...
    (uk.adverts.computer)
  • Clustering
    ... Any idea about doing clustering with sun machines? ... merging many small ... boxes to have a big compute capacity ...
    (SunManagers)
  • Re: Data Type
    ... unless you know you will exceed the capacity of INT (in ... > What is the standard for primary key IDs as far as data type. ...
    (microsoft.public.sqlserver.server)