I have a very similar requirement, and need help. I have a table called 'Listing', each Listing belongs to a specific Category and a SubCategory. I want that in adding a listing once the user has selected the Category, the options of SubCategory displays only the valid SubCategories depending on the selection of Category by the user. I have following tables.

Listing Category SubCategory
------ -------- ------------
ListID CatID SubCatID
Description CategoryName SubCatName
CatID CatID
SubCatID

I was able to establish relationships that the Add form for Listing shows the CategoryNames and SubCatNames. But it shows all the SubCatNames that are in the SubCategory table. I want to show only the ones that belong the selected Category.

How can I achieve this -that in the Add form once the Category is selected, then SubCategory control is constructed automatically with relevant rows from SubCategory table.

I tried defining Global Template as described in the above post, but could not make it work.

I would appreciate if someone can help me with this.

Thanks.

TIF