Hi ;

Im making accounting template for my company.

We tracking all products on product number.

 

I create Customer, Order, Shipment, Orderdetail, Shipmentdetail and product table.

 

But I cant relation between product - orderdetail , product - shipment.

 

Because my customer table relation order and shipment table.

 

order relate to orderdetails

shipment relate to shipmentdetails

 

How to do this relations ?

 

Please help me

I think you'll need to create a second instance of the STOK table so you can the relationship.

 

Click the Add New Table (green +), select your STOCK data source again, give it a different name (such as "Product Card by Shipment Detail"), and save.  Then build the relationship based on Tetk.Ref.No as you indicate in your attachment.

Thanks for your reply Ceath ;

But I add another stok table how to work 2 stok ( inventory) table together ?

 

Because i add new inventory item every day. Thats not static table..

Neredensin kardeş