Recent content by Adam1970

Thanks I need to explain what I'm attempting. On Receiving Form I have 2 cascading combo boxes. 1. PO number 2. PO items. I want to set combo 1 to only show PO numbers where the status is live, hence the reason for the status field in the PurchaseT

Thanks, have fixed this. purchasedetailT is updating. Now just need an update to the purchaseT only when all corresponding purchasedetailT are marked as complete

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