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?