InventOnHand form displays data by a very roundabout way! You will have to change the methods on inventsum table to return the namealias. I think the method is newQuery()
regards
harry
-----Original Message----- From: Steeve Gilbert [mailto:[EMAIL PROTECTED] Sent: Tuesday, 7 October 2003 9:12 a.m. To: [EMAIL PROTECTED] Subject: [development-axapta] Adding new dataSource to Form
Hello everyone,
I need to add the InventTable.NameAlias field to the InventOnHandItem form. The challenge is that the "Find..." and "Filter" (right-click) function must be available for this field. I add a new DataSource called "InventTable" to the InventOnHandItem form. Here's the properties of the new DataSource:
DelayActive : No JoinSource : InventSum LinkType : InnerJoin Table : InventTable
In the form's grid, I add the field and link it to this new DataSource.
(Doesn't seems to be of any help but...) I add a relation on InventSum so that InventSum and InventTable are linked by ItemId.
Results : The field NameAlias is always empty!
With so much try/failed attempt I did discovered that if I set "LinkType" to "Active". The first row and the selected row both have the good NameAlias. But all the others "NameAlias" fields are empty.
Got Tips?
Steeve...
Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
Yahoo! Groups Sponsor ADVERTISEMENT
click here
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.

