Gossamer Forum
Home : Products : DBMan SQL : Discussion :

Re: [TheStone] adding records - two select fields, one updates the other?

Quote Reply
Re: [TheStone] adding records - two select fields, one updates the other? In reply to
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
Subject Author Views Date
Thread adding records - two select fields, one updates the other? timbo 9436 Nov 18, 2003, 6:41 AM
Thread Re: [timbo] adding records - two select fields, one updates the other?
assombracao 9290 Nov 19, 2003, 3:02 AM
Thread Re: [assombracao] adding records - two select fields, one updates the other?
timbo 9312 Nov 27, 2003, 12:07 PM
Thread Re: [timbo] adding records - two select fields, one updates the other?
604 9241 Nov 27, 2003, 1:30 PM
Thread Re: [TheStone] adding records - two select fields, one updates the other?
timbo 9247 Nov 27, 2003, 10:45 PM
Thread Re: [timbo] adding records - two select fields, one updates the other?
604 9297 Nov 28, 2003, 10:43 AM
Thread Re: [TheStone] adding records - two select fields, one updates the other?
timbo 9269 Nov 29, 2003, 12:47 AM
Thread Re: [timbo] adding records - two select fields, one updates the other?
604 9238 Dec 1, 2003, 10:14 AM
Thread Re: [TheStone] adding records - two select fields, one updates the other?
TIF 8676 Nov 9, 2005, 9:02 PM
Thread Re: [TIF] adding records - two select fields, one updates the other?
604 8682 Nov 10, 2005, 9:45 AM
Thread Re: [TheStone] adding records - two select fields, one updates the other?
TIF 8665 Nov 10, 2005, 9:01 PM
Post Re: [TIF] adding records - two select fields, one updates the other?
TIF 8565 Nov 15, 2005, 5:52 AM
Thread Re: [TIF] adding records - two select fields, one updates the other?
604 8526 Nov 17, 2005, 4:54 PM
Thread Re: [TheStone] adding records - two select fields, one updates the other?
TIF 8487 Nov 21, 2005, 8:49 PM
Thread Re: [TIF] adding records - two select fields, one updates the other?
604 8518 Nov 22, 2005, 12:43 PM
Post Re: [TheStone] adding records - two select fields, one updates the other?
TIF 8581 Nov 25, 2005, 8:58 AM