Hi,
Hmm.. Is it the way?

I have item, outlet, outletitem and stockin, stockindetails table.

Table: item
Field: ItemID (PK), ItemCode, ItemName ....

Table: Outlet
Field: OutletID (PK), OutletCode, OutletDesc 

Table: OutletItem
Field: OutletItemID (PK), OutletID, ItemID, CPU, PPU ...

Table: StockIn
Field: StockInID, InvoiceNo, InvDate, ....

Table: StockinDetails
Field: StockInID, StockInQty, StockInCPU ....

In my app, I allow user to stockin for multiple outlet in ONE sotckin transaction. Then, what is the foreign key for the item+outlet of stockindetails table? Should I just use OutletItemID or composite key or.. ??

BTW, is it the way using auto generated value as PK?

Thank you