I have created got two tables:
[FBWelding] which contains weld ID, Welder ID, Project ID, etc
[Welders] which contains Welder ID, Surname, Firstname etc
I want to be able to search by project name and then to view that as a report, I made this query using the table [FBWelding] and because my "Welder ID" field is a look up it shows the primary ID key instead of the Welder ID.
On Office online, it says to resolve this create a relationship, so I changed the join from
[FBWelding] WelderID - [Welders] IDkey ...
to [FBWelding]Welding ID -[Welders]Welder ID
When I attempt to run this query it is saying that I have a mismatch in my expression. In [Welders] the "Welder ID" is text, but then in [FBWelding] the "Welder ID" is a look up.
Does anyone have any ideas how to enable the report to show the value of the look up and not have a mismatch in expression?