Universal Containers wants to track expense reports and expense line items. Values from expense line item records need to be aggregated and displayed on the expense record.
Which type of relationship should an administrator use to ensure that expense line items can be aggregated?
To aggregate values from expense line item records and display them on the expense record, a Master-detail relationship should be used. In this relationship, the expense line items are dependent on the existence of the expense record, and aggregation functions like Roll-Up Summary fields can be used to perform calculations on the child records and display results on the parent record. The Roll-Up Summary field is a feature available in a Master-detail relationship and not an independent relationship type.
Which type of relationship should an administrator use to ensure that expense line items can be aggregated? B. Master-detail The question is "Which type of relationship"? Roll-up Summary is a feature of the Master-Detail relationship.
D. Roll-up summary The roll-up summary relationship type should be used to aggregate values from expense line item records and display them on the expense record. The roll-up summary field can perform calculations on child records and display the result on the parent record.
hey, the roll up is a type of field. What you need is the type of relationship, in this case, Master Detail. Why? Because if you delete de Expense, you delete all the Expense lines that depends on the parent Expense. Expense line isolated has no sense here.