Greetings!

I am trying to generate a form with multiple fields - with each field having different set of look up values.

I was trying to check, if it is possible to pre-populate field values, based on the value selected in the first field drop down.

For example: if Dept = HR, then following field values should be prepopulated
Code = 001, Location = Atlanta

if Dept = Finance, then
Code = 002, Location = Chicago

Lookup Values of Dept, Code and Locations will be predefined.

Please advise.

Thanks in advance...