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

    Sukisu

      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?

       

      Su