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