Solved how i connect 1st description with first selling price , 2nd description with 2nd selling without dublicated

[AHMEDRASHED]

Hello ,
i tray to make invoice print from main form .
how i connect 1st description with first selling price , 2nd description with 2nd selling without dublicated


note : its always matched (descriptions number = selling price numbers ) example 6 description = 6 selling prices

sql :
SELECT tblInvT.InvoiceNumberT, tblInvT.DateT, tblInvT.CustomersNameT, tblDescriptionT.Description, tblSellingT.SellingPriceT, tblSellingT.SellingCurrencyT
FROM (tblInvT INNER JOIN tblDescriptionT ON tblInvT.InvID = tblDescriptionT.DescriptionID) INNER JOIN tblSellingT ON tblInvT.InvID = tblSellingT.SellingIDT;

 

[CJ_London]

looks like you should be linking tblSellingT to tblDescriptionsT, not tblInvT

 

[AHMEDRASHED]

looks like you should be linking tblSellingT to tblDescriptionsT, not tblInvT

i fix it by added a new filed ( row) number and connected together .Thank you for your help @CJ_London