Hello all. Here is my delema. I have two tables from an Access database where Bold indicates the primary key:

Categories (CatID, CatDesc), and ...

Items (ItemID, CatID, categories, name, description, date, cost).

I am trying to set up a Master-Detail relationship with these two tables. I want to design a listbox that will list the categories of the first table, and a datagrid that will display only the items related to the selection in the list box. For example, the list box CatDesc field contains: cars, tools, toys. When I click cars in the list box, I would like only the cars items to display in the datagrid.

I've been reading and trying to figure this out all night but I cant. Please, if anyone can help me out that would be great. So far, I know how to create a connection to my external Access database for this project and how to add it to the Data Source tab but thas all. So if you decide to help me, please keep in mind that I am very, very limited. So if you say to add a dataset, I am totally lost already.

Thanks all,
Scott