J
John
Hi,
I have a form which I use for inputting/editing data to a simple table. Lets
say I have a table of 10"Categorys" and each category is subdevided into
10 "Item Types". I have set up a table which lists "Categorys" in colum one
with corresponding item types in the second colum.That means I have many
repeated "Category" entries but only one "Item Type" entry opposite per
record. I want to simplyfy the selection of the correct combination of
"Category" and "Item Type".I have set up a form with a list box to select
"Categorys" and a "Combo Box" below it to select "Item Type"
Is this the best combination of controls to use . How do I set up the
controls that they are locked to each other....i.e. selecting Category 1 in
the list box only shows the relivent 10 options in the combo box. Can I do
this or is there a better way? Hope thius makes sense,TIA
John
I have a form which I use for inputting/editing data to a simple table. Lets
say I have a table of 10"Categorys" and each category is subdevided into
10 "Item Types". I have set up a table which lists "Categorys" in colum one
with corresponding item types in the second colum.That means I have many
repeated "Category" entries but only one "Item Type" entry opposite per
record. I want to simplyfy the selection of the correct combination of
"Category" and "Item Type".I have set up a form with a list box to select
"Categorys" and a "Combo Box" below it to select "Item Type"
Is this the best combination of controls to use . How do I set up the
controls that they are locked to each other....i.e. selecting Category 1 in
the list box only shows the relivent 10 options in the combo box. Can I do
this or is there a better way? Hope thius makes sense,TIA
John