Auto populate look up fields
Hi,
I have a "Product Type", "Products" and "Sales" form.
In the "Sales" form, i want to choose the Product Type in a look up field (can be radiobutton either) and below i want a look up field that shows only the products belonging to the product type selected in the above "Product Type" look up field.
How can i do it?
Thanks!
Xarana