Formating issue

[aymanmb]

I have 2 tables one for customer names and one for orders which contain the customer name.

The form I am using is having a combo box to read from the customer table as an input method and selection will be writen to the "cutomer field" in order table.

2 issues: 1st is that the value enetered in the "cutomer field" of the order table is actually the customer ID from the customer table. I understand that it is norma since this is what is emant by relational database.

but my 2nd issue is that when I designed a report based on a query of the order form, again what is in the report is the customer ID and not the name.

any way to move around this since I need to see in my report the customer name itself

thanks for helping a novice

 

[Rich]

Base your report on a Query which has the customer's name in the record source