relationships

[cochise]

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?

 

[Pipewelder]

Join on SalesClassID it looks like to me. Same way you did the other.

 

[cochise]

With what join type?

 

[Pipewelder]

It depends on what you want to do. Try all types and see if you get the results you want