storing a keyvalue while displaing other values

Hi everyone,

I'm new here, familiar with relational DBMS but not Filemaker. I have
a question from a collegue who is making something in filemaker pro9.

The question is how to store an ID filed in a table, reference to it
from another table while not showing it in the GUI.

Master table CUSTOMER has fields ID and NAME
Secondary table ORDER has fileds ID, CUSTOMER and SHIP_DATE

The tables have a 1:n relationship on CUSTOMER.ID to ORDER.CUSTOMER

In the screen where the end-user can see and input ORDERs, I want to
show a pulldown with CUSTOMER.NAME visible, but when storing the
screen, the corresponding value of CUSTOMER.ID should be stored in
ORDER.ID. Also when displaying an ORDER, the NAME of the customer
should be displayed instead of ID.

Is this possible in FMP9, and how would I do this? Thanks in advance
(and sorry if this is a FAQ)
.