Gossamer Forum
Home : Products : DBMan SQL : Discussion :

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

Quote Reply
Re: [assombracao] adding records - two select fields, one updates the other? In reply to
Hi

I've decided to go for a version of idea 2).

I'm going to build 7 add forms, one for each category. (Perhaps in the future when I'm better at all of this, I'll do it another way).

So I just need a dropdown on each form which has the products in that category.

I need the dropdown to be built from the following query :

SELECT product_code, product_name
FROM `Product_Category` WHERE
category_code = 'TA'

SELECT product_code, product_name
FROM `Product_Category` WHERE
category_code = 'FL'

etc.

I can't use the generate_full_down routine because it requires the primary table to have a single primary key, and that isn't the case here.

Could someone help me out with a bit of code that will generate the dropdown?

thanks
Tim Ault
Oxford UK
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 9014 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