Populate data in subform

[baldev.1281]

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 of real ship inv, the subform should populate the pending item of that proforma invoice.
any help plz..

thanks
Baldev

 

[sneuberg]

If the table containing the Proforma invoices and the table containing the real-shipping invoices have a one to many relationship and if the subform's Master Link Parents Fields contain the primary key of the Proforma invoice table and the Master Link Child Fields contain the foreign key of the real-shipping invoices table then every thing should be ok.

 

[pbaldy]

Welcome to the site. FYI, thread moved to a more appropriate forum.

 

[baldev.1281]

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 when generating new invoice and insert the pending items of that PFI in tbl_Inv_item and it does well to insert items in table. But the itmes not populating in subform. I'm also a bit new to access, and really appreciate any help in this.

Thanks
Baldev

 

[sneuberg]

In the event where you do the append try requerying the forms that are involved. If that doesn't solve your problem I suggest uploading you database so we can see what's going on.

 

[baldev.1281]

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

 

[jdraw]

Your post seems to focus on part of a system/application.

For your table layout, here is a generic data model dealing with Customers, Orders, Partial deliveries and Invoices. The structure -tables and relationships- may be of value to you. You can adjust as necessary to incorporate your proforma invoices.

Good luck with your project.

 

[baldev.1281]

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