Question Data organization -- help needed

[M0E-lnx]

I have a table that has a bunch of data. I'm already using this data on forms and my database is turning out great (thanks to the help I got here)

Now I have this situation... where this table will get rediculously long.
This is the table that contains information about the things I buy with this database.. We're talking about sort of like a catalog list.
[PartNo] | [Description] | [Price] | [U/M] | [Category] ... etc

When entering information on my ordering form, I need to provide a way for the user to search for parts (listed in that table), so I'm thinking maybe a query that filters by categories.... Like I want to select a category, and I want it to show me all the items under that one category.

Please suggest a way to do it..
thanks

 

[M0E-lnx]

Any ideas?

 

[David Eagar]

Sounds like a cascading combo-box. There are plenty of threads here on the subject

 

[georgedwilkinson]

Or, sans cascading, you can use the built in filter in Access (right click on the category field and type in the filter criteria) or custom build a permanent filter (use the combo-box wizard to let Access do all the work for you).

 

[The_Doc_Man]

I vote for searching the forum for "cascading combo box" as an example, not that George is wrong at all. But I think seeing some of the sample code might make it clearer to you.