Query by Type

[ailyn]

I have a table products
product id - autonum, key
ref - txt
serial - txt
typeId - num (gets type from types table)

and a table types
typeId - autonum, key
type - txt

I want a query to allow my form in a choicelist to pick one of the types and display all available products on that type.

I got :
SELECT types.TypeId, types.Type, products.Reference
FROM types, products
WHERE (((types.TypeId)=[products].[typeid]));

But it doesn't give me that result when I make the form based on that query.

 

[neileg]

You need to change the WHERE clause to point at the control on the form:
WHERE (((types.TypeId)=[Forms].[MyForm].[MyControl]));