Help with relationships

D

Dora

My database is based on the Order Entry Template

My problem is that I have multiple shipments for each order
Each order can have multiple Invoices, each OrderDetailID can ship a certain qty on different invoices

Can someone please help me?
I have created an Invoice Table

ShipID (pk
OrderI
OrderDetailI
InvoiceN
DateShi
QtyShi

I need Invoice no.s to link to OrderID, and OrderDetailID. I can't figure this out

Thanks for any suggestion
 
Top