Hi Follwowing task: make a form that displays Inventtable and the name of the BOMCostGroup/CostgroupId, name of BOMCostgroup must be filterable.
What did I do: Create a form with datasources InventTable and BOMCostGroup, set BOMCOstGroup to be Outerjoined on Inventtable. Create a grid on the form and put the fields from the 2 tables there. Starting the form: everything seems to be okay, the grid displays the name of the cost group correctly. But when I filter on the name of the costgroup, the following happens: All records from Inventtable are still shown but the field for costgroup name is only shown for records that match the filter criteria. What do I want to see? Of course only inventtable records that have the costgroup name as in the filter. It seems to me that Axapta puts the (B.COSTGROUPID = 'something') not in the right place. It puts it into the "left join ...." criteria and not outside. Anybody an idea??? Best regards Helmut ------------------------ Yahoo! Groups Sponsor --------------------~--> What would our lives be like without music, dance, and theater? Donate or volunteer in the arts today at Network for Good! http://us.click.yahoo.com/Tcy2bD/SOnJAA/cosFAA/kGEolB/TM --------------------------------------------------------------------~-> Sharing the knowledge on Axapta. Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/Axapta-Knowledge-Village/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/