join two tables on multi-valued field

[ryansmith44]

Hi All,

I am trying to join two tables on a multi-valued field and getting the error message:
"The multi-valued field '[linking jobs to people].[linking jobs to people]' is not valid in the specified join clause."

the mysql query (excuse table names and column names) is :
"SELECT [linking jobs to people].[full_name], [linking jobs to people].[linking jobs to people]
FROM [linking jobs to people] INNER JOIN [risks per job] on [risks per job].[jobs]=[linking jobs to people].[linking jobs to people]"

Can a join be performed against a multi-valued field?

Thanks a million,
Smudger.

 

[Pat Hartman]

No. And that's yet another reason to avoid them. Create your own 1-many relationships. You loose the "cool" control but everything else works much better.