Home » Microsoft » MB6-704 » What should you set?
You have two data sources named Items and Item Details. There is a relationship between the data sources. Item Details contains detailed information about each item in Items.
You plan to create a form that contains two grids.
You need to configure the form to display the details of an item when the item is selected.
What should you set?
A. The Link Type of Items
B. The Join Source of Items
C. The Link Type of Item Details
D. The Join Source of Item Details
Correct Answer: D
Explanation/Reference:
Item Details is the Child data source. We set the Join Source on the Item Details to Items. See step 5 below.
Note:
You can use form data sources to join tables that create a parent/child relationship between data records. Typically, the records from the data sources are visually separated on the form. For example, you use a grid to list order records and a second grid that us lists the order lines associated with each order. The following steps show how to add and join the tables.
To Join Data Sources that Create Parent/Child Links
1. In the AOT, expand the form, and then expand the Data Sources node.
2. Press CTRL-D to open a second AOT, expand Data Dictionary, and then expand Tables. The AOT lists the tables you can use as a form data source.
3. To add tables to the form data source, drag two tables and drop each table on the Data Sources node of the form in the first AOT. The tables are added as data sources to the form.
4. Identify the table you will use as the parent data source. The other table will be the child data source.
5. Set the JoinSource property on the child data source to the name of the parent data source.
6. Set the LinkType property of the child data source to Active, Passive, or Delayed. The LinkType property specifies how to update the child data source in response to a change in the parent data source.
7. Create the form design, and then add fields from each data source to the form. Typically, you add two grid controls. One grid displays fields from the parent data source. The second grid displays fields from the child data source.
Reference: How to: Join Parent/Child Data Sources for a Form [AX 2012]