Displaying different information in a field
I am working on a project that requires relationships with multiple tables. The key to making all of them work is through a unique entity id number. My question is, can a field house data but display something different?
I would like a field to store the entity id number so it can relate to another table but want it to display the person's name instead of the number. Can you do that?
My knowledge of Filemaker is slim, so please break it down for me if you can figure it out.