field 1 = field 2 from other record
Example; (all fields in same table)
field A is an auto enter serial number,
field B is lets say a boys name
field C is initially an empty edit box, into which I intend entering one of any of the serial numbers (field A) already created in existing records.
field D will be a calculation (I assume) that will display the boy's name (from field B) depending on the value set in field C.
I assume I'm looking at a calculation that involves a script, which is new ground for me, or am I looking to overcomplicate something that's quite simple really.