Report - Convert ClientID to Client Name

[Guest]

I am trying to convert the ClientID to client’s name.

I have;
TABLE
tbl_Client
ClientID
ClientName
ClientAddr
ClientPhone
Tbl_Order
OrderID
ClientID
Account
OrderDate

The clientID is link to tbl_client

QUARIES
Qry_OrderSearch
OrderID
ClientID
Account
ClientName
OrderDate
Qry_Journal
OrderID
ClientID
Account
ClientName
OrderDate
etc

The clientID is link to the tbl_Order

REPORT
rpt_Order
OrderDate
ClientName
ClientID
Account
The clientID is link to the tbl_Order, because the result is query from the
order. How can I get the ClientName show instead of the client ID?
Since I use qry_Journal I have to put on “Control Source =[ClientID]
My question is how can use this clientID link to clientName.

 

[Guest]

Change the ClientID field on your report to a combo box and in the record
source go to the query designer and select tblClient and select ClientID and
ClientName onto the design grid.
Then on its properties set bound column to 1 and column widths to 0 and
column count to 2.
And run the report again and in the place of clientID, there should be
ClientName showing.
Hope this helps.