Here is a simplified relationship I have:
tblInv (InvNum, InvDate, InvAmount)
tblInvSalesClass (InvNum, InvDate, SalesClassID)
tblSalesClassInfo (SalesClassID, SalesClassDesc)
tblInv -> tblInvSalesClass - joined on InvNum
(all from tblInv and only those that match the join field from tblInvSalesClass)
How do I set up the relationship between tblSalesClassInfo and tblInvSalesClass? Do I have to use duplicate tables?
tblInv (InvNum, InvDate, InvAmount)
tblInvSalesClass (InvNum, InvDate, SalesClassID)
tblSalesClassInfo (SalesClassID, SalesClassDesc)
tblInv -> tblInvSalesClass - joined on InvNum
(all from tblInv and only those that match the join field from tblInvSalesClass)
How do I set up the relationship between tblSalesClassInfo and tblInvSalesClass? Do I have to use duplicate tables?