Skip to Content
avatar image
Former Member

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

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.

Regards,

Raj

fieldcriteria.jpg (16.4 kB)
association.jpg (12.8 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers