Queries

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have created a query that when shown in the datsheet view shows exactly the
way that I want the information to display on my master database for a field
ManagingAttorney. I want to show both columns for ClientName and MALastName.


I have a client table with the fields: ClientID and ClientName.
In the query, I have ClientID:ClientName, to show the ClientName instead of
the ClientID on the form.

I also have a ManagingAttorney table that has the MAID and MALastName, this
table also has ClientName pulling information from the table with the
ClientID.

The query is as follows:

ClientID:ClientName and MALastName, both from the ManagingAttorney table.
In the form, the control source is this query, but when I go to the form
view, it is showing the clientID instead of the ClientName. Help.
 
Hi Sharon,

The problem is that you try to reassign a pre-defined the column name
(ClientID).
If you use a "_" in ClientID, then it will be ok then.

Client_ID:ClientName

Hope this answer your question.
 
JL, I really appreciate your help. I feel like such an imbecile, but when I
try to put Client_ID it says is not on the list. One thing that I am
confused about is that I have so many tables: ManagingAttorney, ClientInfo,
MasterDatabase, etc. that all have either the ClientName and/or the ClientID.
When performing the query, I am not sure which table to use to get the
ClientID/ClientName from. Help.
 
Back
Top