H
hoachen
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.
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.