Multiple lookup-fields referencing same form
So in form1, I have lookup fields lookup1, lookup2 corresponding to field1 and field2 in form2.
Whenever I change value in lookup1, I want value in lookup2 to change to the field2 value in the same row in form2..... this is dumb request... but can it be done?