Skip to Content

Setup Field Criteria in MDF objects to filter values using association and/or field criteria

Oct 09, 2017 at 03:12 PM


avatar image

Objective: under Manage Data: I would like to filter Field2 value by Field1 values. e.g. If Field1 value is USA then Field2 should appear with only N1, N2 and nothing else. and same with other countries. I would like to do it using association, field criteria. No business rule.

This is my scenario:

Parent MDF object = Country (usual MDF FO)

Child MDF Object = mycity (custom GO)

Effective dating= Basic

Association -> ONE to MANY -> Country

Three values are stored under "mycity"

e.g. N1 under Country=USA

e.g. N2 under Country=USA

e.g. M1 under Country=India

e.g. P1 under country= Japan

Final MDF object where I recall above objects = mainform

Effective dating = Basic

Field1 (Name of country) = "Country" (GO)

Field2 (Name of my city) = "mycity" (GO) -> Under Field2 "Field Crieteria" set as below

I appreciate your direction.



fieldcriteria.jpg (16.4 kB)
association.jpg (12.8 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers