Print Customer Name instead of cutomer ID listed on form?

[AccessBeginner99]

Does anyone know how I can print the customer name from a form that only displays the customer ID?

Thank you,

AB99

 

[theDBguy]

Hi. Welcome to AWF!

Yes, you can join the lookup table in your query and add the name column.

PS. I moved your thread out of the Introduction forum.

 

[The_Doc_Man]

What theDBguy said is correct, but with a caveat... is the ID/name combination in a table of its own or is it part of a Lookup Field?