4 Replies Latest reply on Feb 6, 2012 7:48 AM by RayCologon

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


      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?