Look up relationship mismatch

[char]

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?

[June7]

Sounds like the WeldersID field in FBWelding is actually saving the autonumber ID field from Welders, not the text WelderID.

You need to either:

query join on FBWelding!WelderID and Welders!ID

or

change the WelderID field in FBWelding to text and save the text WelderID also change the PK in Welders to the text WelderID and the autonumber ID is unnecessary

[char]

You have to have the ID as a field in the web compatable version, it can't be deleted and you can't make any other field a primary key.
When I try to join them in a query, that is when I get the 'type mismatch in expression' error message.

[June7]

Join the tables on the pk/fk number fields then all related info of both tables, including the text WeldersID field, will be available.

[char]

on the normal Access I would be able to do this, however Im not aware of primary and foriegn keys on the web compatable version, I thought it had been disabled?

[June7]

I don't understand how a web database join would be any different than normal db.

If you save the pk autonumber Welders!ID to FBWelding table in a number field then this is a fk. These are the common fields that query join would be done on.

[char]

I was trying to join it with the Welders!WelderID field that was why I was getting the mismatch message. Joined it to the automated ID and it appears to work. Thanks for your help!