Data Access lookup fields

Data Access lookup fields

Hello 

I need some experts help asap to make the below function workable. Very simple...yet...

FORM CATALOG: 

  • Product_name will list only Products on the selected Category.
  • Price will show selected product price

Have created 3 forms:

Form Product_Group containing Category (field)

Form Products containing Category (lookup), Product_Name and Price fields

Form Catalog containing Category, Product_Name lookup fields and  Price currency field


Tried already filters, fetch record, for each record, an several scripts I´ve found in zoho resources and nothing seems to work.

Any help will be much appreciated!

All best

Carol