Help Me Fix This Querry

  • Thread starter Thread starter Aamer
  • Start date Start date
A

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
 
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.

smartin said:
Aamer said:
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
Click to expand...

Is COMPANY NAME actually stored in the invoice detail table?
Click to expand...
 
Back
Top