look ups help required

[John thomas]

I currently have a database wear i use a combo box to look up products then i use a second look up box to select the suppliers of those products .I have quickly realised that i have to many products ,so now i need to look up catogories as well ,this all seems a bit cumberson.Is there a way wear I can go into a bigscreen to display all my catagories click the catoggrie reqd and go auto matically to the products .When selecting he product can it insert it into the reqd field and also insert the supplier in the apropriate field

 

[John Big Booty]

I think you might be looking for a Cascading Combo Box set.