Lookup Forms

[David]

What i am trying to do is use Access as a lookup tool.
Where as first box gives main catagories. Then based on
selection there may or may not be a secondary catagory
selection. I am loooking at doing this to 4 levels. At
the end I need it to generate a desciption and price. Is
this something that is possibel with Access from a
beginners level. Or do I need and expert to do this?

Thanks for the info

Dave

 

[John Vinson]

What i am trying to do is use Access as a lookup tool.
Where as first box gives main catagories. Then based on
selection there may or may not be a secondary catagory
selection. I am loooking at doing this to 4 levels. At
the end I need it to generate a desciption and price. Is
this something that is possibel with Access from a
beginners level. Or do I need and expert to do this?

David,

This is just a step past beginner level: you need to create a little
bit of VBA code. You will need a Form based on your table to do this
(you cannot do it in a table datasheet); the form would have (I
presume) four combo boxes. Each combo box after the first would be
based on a Query referencing the prior combo box.

Check http://www.mvps.org/access and search for "correlated combo box"
for some sample code.