hi ,
i have tables tblrequisitions and proformachilditems .
What i need is to update ALL records in table proformachilditem of the field RFQ with values from tblrequisitions field OurRefNo WHERE (proformachilditems.RFQ is null) and proformachilditems.connect = tblrequisition.IdCounter
so if someone can send me the sql query i can use in a before update action will be appreciated