Hi
I hope someone can help, I have 3 tables
PurchaseT - Containing PurchaseID & Status
PurchaseDetailT - Containing PurchaseDetailID, PurchaseID & Complete (Y/N)
ReceivingT - Containing PurchaseDetailID, PurchaseID & Complete (Y/N)
When selecting yes in the complete field in the ReceivingT i want the corresponding complete field in PurchaseDetailT to update to Yes.
then
if all lines are set to yes in PurchaseDetailT for the corresponding PurchaseID, i then want the PurchaseT status to change from default value "Live" to "Complete". If not complete it should remain "Live"
I look forward to your comments