Search results

thanks dear. let me go thru your link and will update you, m sure it will help me out.

Dear Steve, sorry for late reply. I was trying as you advised but couldn't figured it out and uploading my file for your review. my work flow is- 1- PFI (make proforma) 2- MF (process for approval) 3- Shipping (actual shipment) thanks Baldev

Thanks sneuberg. actually i have below tables- 1- tbl_PFI (proforma heading details) PFID is PK 2- tbl_PFI_Items (proforma Item details) PFID IS FK 3- tbl_Shipment (Shiping Inv Heading details) SNo is PK 4- tbl_Inv_Items (Shiping item details) I was trying with append qry to run every time...

Hi, I'm working on a database for logistic solution where user- 1- records Proforma invoices 2- real-shipping invoices (one proforma can be shipped partially, mean 2-3 real shipping invoices. So I use BL number as PK.) now I want that each time when user put PF inv number in main form on time...