Making data appear in one field relating to what's entered on another field

Discussion created by Sukisu on Feb 6, 2012
Latest reply on Feb 6, 2012 by RayCologon

Hi there,


This is my first post, so please be gentle.


I'm trying to create a field with "project names" that links to the "project code" when entered.


I'm currently using a value list linking into another table for the "project code" field, and can get it to show a list of both the project codes and project names in the drop down box, but only the project code displays on the layout. What I want to do is automatically enter the project name into the project name field whenever the project code field is chosen.


Can anyone help?