Here is what I am trying to do (in a simple example) -
Existing list List A -
Color Name Color Number
List B -
A User enters in information, and one of the required fields is "Color". This column is set up as a lookup of the "Color Name" values in List A. We would like the next field in List B to be automatically set to the "Color Number" field that coorosponds with the users choice in the Color Name column.
Is there a way to do this? (With out custom programing - or simple code at least as I know Designer but I am NOT a programmer.)
Thanks in advance!