I am attempting to update two tables. I have a parent table and child table, and when updating the parent table I also want information in the child table to be updated as well, but I cannot seem to get the update statement to work as expected.
What I am attempting here is when updating the parent table to also update the ttblSalesAppt table column txtAppts.
I already have a select statement where the information is pulling correctly from the ttblSalesAppt table, but at this point I am having to update that table seperatly in order for the select statement to show up correctly.
I hope I have provided enough information regarding this issue.
Would it be smarter to attempt a stored procedure for this also, I have never written one, but have read where this could be used for this situation.
SET txtLocation = @txtLocation, dtDate = @dtDate, dtPartyTime = @dtPartyTime, txtLNameGuest = @txtLNameGuest, txtFNameGuest = @txtFNameGuest,
txtProgCode = @txtProgCode, txtMktgComment = @txtMktgComment, txtBooker = @txtBooker, txtComments = @txtComments, ckShow = @ckShow,
ckNoShow = @ckNoShow
FROM tblSalesManifestGAA INNER JOIN
ttblSalesAppt ON tblSalesManifestGAA.pkSalesManGAAID = ttblSalesAppt.pkSalesManGAAID
WHERE (tblSalesManifestGAA.pkSalesManGAAID = @pkSalesManGAAID)