I am aware this can be done in some magical way!
1. I have a combobox property on a feature Operation cadPrimary named TenureTypeFilter it has an SQL domain list with this value SELECT DISTINCT TENURE_TYPE FROM PROGEN_LMS_LAND_VIEW1 WHERE (LAND_TYPE = 'Primary') it returns a list of all tenure types !
2. I have a feature named cadPrimary it has a combobox property named LMSID_LINK with this SQL SELECT UNIQUE_ID, PRI_LOT_PLAN + ' - ' + UNIQUE_ID AS DISPLAY FROM PROGEN_LMS_LAND_VIEW1 WHERE (LAND_TYPE='Primary') AND (TENURE_TYPE='FREE') it returns all values that have TENURE_TYPE of 'FREE' !!!
I would like to replace the SQL with this! SELECT UNIQUE_ID, PRI_LOT_PLAN + ' - ' + UNIQUE_ID AS DISPLAY FROM PROGEN_LMS_LAND_VIEW1 WHERE (LAND_TYPE='Primary') AND (TENURE_TYPE='[cadPrimary/TenureTypeFilter]')
When the user changes the operation property it needs to update the feature property list instantly! not the next time the user edits/adds a feature
Giving the user the ability to filter the list to the particular tenure type required! however I'm no magician :(
Any takers?