Use trigger to select values in one field based on values in another
Hi community, You guys are great and I really appreciate all your help! If I have a field that has 12 values say A, B, C and woul like each of those to trigger the selection of a different value say 1, 2, 3, how would I do that? I think I'd need to use a trigger. I'd like something like selecting A in field ONE to select 1 in field TWO and selecting B in field ONE to select 2 in field TWO.
You must be careful in this situation because of the possible associations in your data. In the example I've uploaded I tried to make the schema resemble your schema. But in my data set there is no relationship between AWM in USER_LOB and AWM in INACTIVEUSER_LOB. So this will not work for that particular LOB. It will work with other LOB's because there is a relationship within the data.
Hope this helps. Look at Sheet 1 for your particular request. Select a value in USER_LOB and click the Test LOB button. Check the properties under action for what I've done:
In your particular case you may want to change your schema to have a relationship between the USER_LOB and INACTIVE_USER_LOB.