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 Links
- To visit your group on the web, go to:
http://groups.yahoo.com/group/development-axapta/
- To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
- Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.