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...