Hi,
In my InfoPath 2010 form I have dropdown field 'Project' and another dropdown 'Priority'.
I want to set default 'Priority' value to the same as the last record with that project.
example:
Project | Priority
a | 20
a | 30
b | 5
I create another record, change 'Project' value to "a" and the value of Priority suppose to set to 30.
I'm thinking about creating new datasource with sql query. Then set up new rule when changing 'Project' and set 'Priority' value.
Do You think, that there is some other way to achieve it?