Returning the correct value from another table

[Jodie]

Hi - I can't work out what I'm doing wrong with this SQL syntax.

This is in a submission page, and I want to present to my user a field from another table based on the item they selected. So if they selected item 6 on the previous page, I want it to return more details about item 6 on the next page. But no matter what I do, the syntax always returns the first value in the other table. Any help would be much appreciated. Thanks

ISNULL((SELECT (Field4) FROM PW_tbl_progitems WHERE progitemid='[@field:progitemid]'),0)

[CoopperBackpack]

Hello @Jodie,

Please test the statement with the 'target' keyword.

ISNULL((SELECT (Field4) FROM PW_tbl_progitems WHERE progitemid=target.[@field:progitemid]),0)

According to your description, it looks like you pass the selected value as a parameter. In this case, the syntax should be:
 

SNULL((SELECT (Field4) FROM PW_tbl_progitems WHERE progitemid='[@progitemid]'),0)

 Feel free to update this thread if you have further questions.  

[Jodie]

Thank you - That was perfect and exactly what I was looking for!!!!!