MB6-704 · Question #92
You are developing a solution to store sales orders in Dynamics AX. Each sales order can contain multiple sales order lines. A sales order line can be part of only one sales order. You create two…
The correct answer is C. A foreign key relationship from Sales Line to SalesTable. Create a foreign key relationship in the Sales Line, which is on in many-side of the relationship, to the Sales table, which is on the one-side of the one-to-many relationship.
Question
You are developing a solution to store sales orders in Dynamics AX. Each sales order can contain multiple sales order lines. A sales order line can be part of only one sales order. You create two tables named SalesTable and SalesLine. The tables will model the sales order and the sales order line entities. SalesTable will store sales orders and SalesLine will store sales order lines. You need to specify the relationship between the tables. Which relationship should you specify?
Options
- AA foreign key relationship from Sales Table to Sales Line
- BA field fixed relationship from Sales Table to Sales Line
- CA foreign key relationship from Sales Line to SalesTable
- DA related field fixed relationship from Sales Line to Sales Table
How the community answered
(42 responses)- A2% (1)
- B12% (5)
- C81% (34)
- D5% (2)
Explanation
Create a foreign key relationship in the Sales Line, which is on in many-side of the relationship, to the Sales table, which is on the one-side of the one-to-many relationship.
Topics
Community Discussion
No community discussion yet for this question.