Help Me Fix This Querry

[Aamer]

am trying to create a querry to use in making an invoice



following is the querry in SQL view


SELECT Challan.[Challan #], Challan.[Trans ID], [Sales Org Desc With
Modified Descrip].CompanyName, [Sales Org Desc With Modified
Descrip].[Transaction Description], [Sales Org Desc With Modified
Descrip].[Modified Item Description], [Sales Org Desc With Modified
Descrip].Price, [Sales Org Desc With Modified Descrip].Odered, [Sales Org
Desc With Modified Descrip].Units, ([Price]*[Odered])-[Discount] AS Total,
[Sales Org Desc With Modified Descrip].Seller, Company.mobile, [Sales Org
Desc With Modified Descrip].[Struck#], [Sales Org Desc With Modified
Descrip].[Entry Type], [Sales Org Desc With Modified Descrip].[Sales Type]
FROM Company INNER JOIN (Challan INNER JOIN [Sales Org Desc With Modified
Descrip] ON Challan.[Trans ID] = [Sales Org Desc With Modified
Descrip].TransId) ON Company.CoId = [Sales Org Desc With Modified
Descrip].CoId;


the problem am facing is if by mistake a transaction is added in the querry
whose COMPANY NAME differs from another transaction that is eliminated in the
invoice.

This is not what i want, i want all the transactions in that perticular
invoice to dissappear instead.

Can Someone Please Help me fix this problem.

Thanks in advance

 

[Aamer]

No COMPANY NAME is stored in COMPANY TABLE on the form "CHALLAN" when i
select the name of company from combo box it picks it from COMPANY TABLE and
stores in CHALLAN DETAIL TABLE along with other detail.

am trying to create a querry to use in making an invoice



following is the querry in SQL view


SELECT Challan.[Challan #], Challan.[Trans ID], [Sales Org Desc With
Modified Descrip].CompanyName, [Sales Org Desc With Modified
Descrip].[Transaction Description], [Sales Org Desc With Modified
Descrip].[Modified Item Description], [Sales Org Desc With Modified
Descrip].Price, [Sales Org Desc With Modified Descrip].Odered, [Sales Org
Desc With Modified Descrip].Units, ([Price]*[Odered])-[Discount] AS Total,
[Sales Org Desc With Modified Descrip].Seller, Company.mobile, [Sales Org
Desc With Modified Descrip].[Struck#], [Sales Org Desc With Modified
Descrip].[Entry Type], [Sales Org Desc With Modified Descrip].[Sales Type]
FROM Company INNER JOIN (Challan INNER JOIN [Sales Org Desc With Modified
Descrip] ON Challan.[Trans ID] = [Sales Org Desc With Modified
Descrip].TransId) ON Company.CoId = [Sales Org Desc With Modified
Descrip].CoId;


the problem am facing is if by mistake a transaction is added in the querry
whose COMPANY NAME differs from another transaction that is eliminated in the
invoice.

This is not what i want, i want all the transactions in that perticular
invoice to dissappear instead.

Can Someone Please Help me fix this problem.

Thanks in advance

Is COMPANY NAME actually stored in the invoice detail table?