Help Multi value field queries not working (Update or Insert)

[ideasfactory]

Hi,

I am trying to update a multi value field Test_Assigned in Table B with the ID field from TableA. The TableB Assigned field and TableA Name field contain join data, there are records that do not have data in TableB Assigned so I have selected record 2323 to test.

When I run the following query record 2323 is not updated, please help correct the query.



UPDATE TableB INNER JOIN TableA
ON [TableB].[Assigned] = [TableA].[Name]
SET [TableB].[Test_Assigned].[Value] = [TableA].[ID]
WHERE ([TableB].[UID] = 2323);

Thanks

[ItsMe]

What is a multi value field? Are you entering multiple values separated by a comma into a single field or are you using a lookup field at the table level?

What happens if you assign an index number to your field you are trying to update? Also, .Value is used in VBA, not SQL

UPDATE TableB INNER JOIN TableA
ON [TableB].[Assigned] = [TableA].[Name]
SET [TableB].[Test_Assigned] = 1
WHERE ([TableB].[UID] = 2323);