You have two data sources named Items and ItemDetails. There is a relationship between the data sources. ItemDetails contains detailed information about each item in Items. You plan to create a form…

Question

Options

• AThe Link Type of Items
• BThe Join Source of Items
• CThe Link Type of Item Details
• DThe Join Source of Item Details

• A
  3% (1)
• B
  6% (2)
• C
  6% (2)
• D
  84% (26)

Explanation

Item Details is the Child data source. We set the Join Source on the Item Details to Items. See You can use form data sources to join tables that create a parent/child relationship between data Typically, the records from the data sources are visually separated on the form. For ex- ample, 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.

No community discussion yet for this question.