how to to filter data category wise in filemaker pro 12?

I am working on filemaker pro 12. I made 3 tables category, product and product_catalog. category table having two fields- (1)cat_id (2) category

product table having fields- 1- pr_id 2- category(dropdown list) 3- pr_name 4- price

product catalog having fields- 1- category(dropdown list) 2- product(dropdown list) 3- price

I fill the dropdown fields using value lists . I want on product catalog , when anybody choose any category then next dropdown show only that category products.. I also related the tables from cat_id to category Of product_category of product. product code to product of product table. Have any body solution..??? Thanks in advance...............

Answers


In your value list definition, try the "only show related records" option.


Need Your Help

How can I upload an image using AJAX to google cloud storage?

python ajax google-app-engine image-uploading google-cloud-storage

I'm new to Python Development, so in your answer please consider to not leave out things you may consider obvious. (I'm used to PHP development)

pylintrc file not being detected in LiClipse

eclipse pydev pylint liclipse

This is the command that is run by LiCLipse