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 9133 Nov 18, 2003, 6:41 AM
Thread Re: [timbo] adding records - two select fields, one updates the other?
assombracao 8993 Nov 19, 2003, 3:02 AM
Thread Re: [assombracao] adding records - two select fields, one updates the other?
timbo 9013 Nov 27, 2003, 12:07 PM
Thread Re: [timbo] adding records - two select fields, one updates the other?
604 8944 Nov 27, 2003, 1:30 PM
Thread Re: [TheStone] adding records - two select fields, one updates the other?
timbo 8950 Nov 27, 2003, 10:45 PM
Thread Re: [timbo] adding records - two select fields, one updates the other?
604 8999 Nov 28, 2003, 10:43 AM
Thread Re: [TheStone] adding records - two select fields, one updates the other?
timbo 8972 Nov 29, 2003, 12:47 AM
Thread Re: [timbo] adding records - two select fields, one updates the other?
604 8936 Dec 1, 2003, 10:14 AM
Thread Re: [TheStone] adding records - two select fields, one updates the other?
TIF 8378 Nov 9, 2005, 9:02 PM
Thread Re: [TIF] adding records - two select fields, one updates the other?
604 8384 Nov 10, 2005, 9:45 AM
Thread Re: [TheStone] adding records - two select fields, one updates the other?
TIF 8367 Nov 10, 2005, 9:01 PM
Post Re: [TIF] adding records - two select fields, one updates the other?
TIF 8267 Nov 15, 2005, 5:52 AM
Thread Re: [TIF] adding records - two select fields, one updates the other?
604 8229 Nov 17, 2005, 4:54 PM
Thread Re: [TheStone] adding records - two select fields, one updates the other?
TIF 8190 Nov 21, 2005, 8:49 PM
Thread Re: [TIF] adding records - two select fields, one updates the other?
604 8220 Nov 22, 2005, 12:43 PM
Post Re: [TheStone] adding records - two select fields, one updates the other?
TIF 8283 Nov 25, 2005, 8:58 AM