aaasam - Tuesday, November 22, 2011 6:14 PM:
I am looking for some help to resolve this, albeit simple, problem myself as a "noob" to aras Innovator cannot solve.
I need to create a report that will be printed from a main input form. The main input form has 3 tabs associated with it. All 3 of these tabs are different item type tables, with different information (ie: recipes, contacts, and questions).
Can someone help me learn (via examples if possible) how to go about writing the AML to get all of the "recipes" related to the main form input along with its related "Contact info" and "Questions"?
So far.... I have been able to code the AML to obtain one field from the Recipe relationship. But, I also am needing a couple of fields (up to "X" times) from the "Contact" item type AND a couple fields (up to "Y" times) from the "Questions" item type.
Does this make any sense?
Essentially there is a parent form with up to "X" recipe relationsips, up to "Y" contact relationships and up to "Z" question relationships all relating back to the parent input.
Thanks!
aaasam - Wednesday, November 23, 2011 2:52 PM:
Some improved news as the "noob" learns a little more....
I now have a very basic report that will "get" the parent and all the items from the 3 relationships, here is my new question:
1) how do I pass to the report the value needed by the report to "get" this information?
- I have a property called <tasting_id> which is the "driver" for obtaining the parent and all of the children relationship items. How do I pass the value that is populated in this field, on the form, to the report for the query when the user is viewing the item on the form and click the `report toolbar option to see the formatted report?
2) given that for any given recipe tasting, there could be 0 to "X" contacts being asked to participate and there could be 0 to "X" questions we want the contacts to complete as part of the recipe tasting...... how do I iterate "loop" through the multiple items returned by each relationship. Such as:
Recipe = tomato soup
Contacts = Jane Doe, John Doe, and Doe Doe
Questions = Was it tasty? Would you buy it?
I need to build a report with the recipe information and its associated questions for Jane Doe. A separate report page for John Doe. A final separate report for Doe Doe.
**** I AM READY TO LEARN ****
