Updating tables

[Adam1970]

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

[Bob Fitz]

Cross-Posted: https://www.access-programmers.co.uk...tables.328727/

Please read: https://excelguru.ca/a-message-to-forum-cross-posters/