1

I have wondered about this for years and have seen questions posted out there on this but never have found an answer.

Let's say you have a Form with datasource A, B, and C. "A" will act as the parent and both "B" and "C" join to "A" as an Inner Join. Now, I have logic on the Table object of A in the modifiedField() method. Inside that method, you should be able to access relating data by using this.joinChild(). However, since there are multiple child datasources, which one will it pick? And also, how do I access the one that it doesn't automatically pick?

I found there is a this.datasource(), but I didn't see any methods within that would seem to get to other datasources.

codemann8
  • 372
  • 7
  • 29

1 Answers1

1

As joinChild takes no arguments, you will have to rearrange your datasources to have one child only like in this question: Display Methods - Multiple Form Data Sources. This can be done in AX 2012 by linking C to A directly using the third argument to addLink. You can then use A.joinChild().joinChild() to reference C.

Or you will have to move your logic to the form where the records can be referenced directly.

Using joinChild in the modifiedField method is a sure sign of trouble, as you cannot be sure that a field is modified in a context of a join.

Community
  • 1
  • 1
Jan B. Kjeldsen
  • 17,817
  • 5
  • 32
  • 50
  • So, could I inside modifiedField, check to see if .dataSource() is null to determine if it came from a form? Note, this table "A" is a custom table which is a setup table that will only have one form that edits that data. – codemann8 Mar 25 '14 at 16:57
  • 1
    Testing for null is a good idea (but verbose).
    `FormDataSource fds = this.datasource();` `FormDataSource cds = fds ? fds.joinChild() : null;` `YourTable t = cds ? cds.cursor() : null;` `ret = t && t.check(this);`     – Jan B. Kjeldsen Mar 26 '14 at 07:46