SQL SELECT based on values from another row

[DRSinclair]

Hi,

I have a table containing various contact address, on a sales invoice document i have i would like to be able to append the value of a text control called BuCode onto a Select statement to return the correct contact name, i have tried this in the Finish and OnRow methods, but i get errors any ideas?

me.datavalue=SELECT CONTAC FROM ccCons WHERE Con_CODE='000000000' & (BuCode)

 

[ASG0856]

Why not do it in the Sql itself?
Specifically as a 'calculated' field

 

[DRSinclair]

Thanks for the reply, i fixed this by putting it in the BuildFromRow method before the Super call and changed the text to...

ExecuteSQL="SELECT CONTAC FROM ccCONS WHERE Con_Code='000000000" & BUCode & "'"

Cheers
Dave