Adding subform missing composite primary keys

[Avaya]

Hi All

When I tried to add another subform to an existing subform, the "InvNbr"
field is missing from the invoice table. My table structure is as follows:

tblVendors
VdrID PK
Vendor

tblOrders
VdrID FK
OrderNbr PK

tblInvoice
VdrID PK
InvNbr PK
OrderNumber FK

tblPayments
VdrID FK
InvNbr FK
CheckNbr
CheckAmount

This is the first time I used multiple fields for my primary keys and I
don't know how to get my form to work.

Thank you.

 

[Avaya]

Hi,

Can someone help me? How do I link tblPayments to tblInvoice and why do
"invnbr" not available in tblInvoice?

Thank You

Avaya