Custom data rules for a table when a filed changes value
In my Asset form, I have two fields Asset Class and Eval Group 1 that are related. Both are drop down fields in the Asset form. Each Asset Class selected will drive a dropdown of a subset of values in the related field Eval Group1. That is the top line below if chosen as the Asset Class will have the rows under that show up i the drop down for Eval Group1.
| Computer_Equipment - Asset Class | Office_Equipment - Asset Class |
| MCE - Misc. Computer Equipment | OFFC - Office Equipments |
| SERV - Servers | COPY - Copiers |
| PC - PC, Laptop, and workstations | PHON - Phone Equipments |
| PRNT - Printers |
So, i have all of this set up and working fine. During testing, my analyst noticed that if she selected Computer Equipment and then correctly selected say "PC" for Eval group, she could then go back and change the Asset Class to something else and the form would allow that.
How do I create a Custom Data rule at the table level to stop this from happening? I thought if I could say, if value of "Asset Class" changes, change "Eval Group 1" to <blank> forcing the analyst to re-choose Eval Group 1.
How would we write a formula like that in Custom Data rules at the table level?
Thanks
Deepa
------------------------------
Deepa Prashant
------------------------------
