AnsweredAssumed Answered

field 1 = field 2 from other record

Question asked by WinstonChurchill on Nov 7, 2010
Latest reply on Nov 8, 2010 by WinstonChurchill

Title

field 1 = field 2 from other record

Post

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.

Outcomes