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 Sales Table and Sales Line. The tables will model the sales order and the sales order line entities. Sales Table will store sales orders and Sales Line will store sales order lines.
You need to specify the relationship between the tables.
Which relationship should you specify?
A. A foreign key relationship from Sales Table to Sales Line
B. A field fixed relationship from Sales Table to Sales Line
C. A foreign key relationship from Sales Line to Sales Table
D. A related field fixed relationship from Sales Line to Sales Table
