Hi, you can write a query in execute query of salestable and salesline datasource which will do the same that you expected.
Regards, Muthukrishnan ----- Original Message ---- From: vijay kishore raju <[EMAIL PROTECTED]> To: development-axapta Development <[email protected]>; axapta-knowledge-village village <[email protected]>; 4axaptaprofessionals Axapta-professionals <[EMAIL PROTECTED]> Sent: Tuesday, 16 January, 2007 7:23:49 PM Subject: [development-axapta] Help on Filters Hi every one, As we know the header of the SalesTable form consists of SalesOrders and the below part is the Line Items details. Iam stuck here with the situation: All i've to do is i need to create a new form with the same header and lines.But i need to display 1. Only the SalesOrders which are invoiced and 2. SalesLine items which are of type Warrenty. First situation can be figured out, but the problem is with the second condition: Here is the Details Description: SalesLine items are sopposed to check with the InventTable. ItemId for InventTable. ItemGroupId = 'WarrentyCode' and i need to display only these salesorders which have atleast one warrenty item in there lines. Here we can filter the Header section and based on the JoinSource the below section(lines) will be filtered automatically. But now we have filter the Header Section based on the Line Items(Warrenty Items). Can any body PLZ help me out ------------ --------- --------- --- Need a quick answer? Get one in minutes from people who know. Ask your question on Yahoo! Answers. [Non-text portions of this message have been removed] __________________________________________________________ Yahoo! India Answers: Share what you know. Learn something new http://in.answers.yahoo.com/ [Non-text portions of this message have been removed]
