Hello i would like to make a field’s lookup options dependent on the value selected from another lookup field.
For example i have 3 tables with the following attributes:
- Department: department,subunit(composition inverse attribute)
- Subunit: subunit
- Employee: department(lookupicker field), subunit(lookuppicker field)
In the above scenario subunit is a composition attribute in department.
In employee editor how do i make lookup options for subunit field show only subunits related to the department chosen from the department lookuppicker field?