Creating the Complaint Line table

Alright! Let's take a look at our requirement list and see what we've accomplished so we can get them marked off as follows:

The next thing on our requirement list will require a different table. How do we know this? Because we've thoroughly looked through the Sales Header and Sales Line tables and we've seen what information should go where.

The requirement list says that we need to have one or more items per incident. This should be the leading indicator for you to know that the information related to the item belongs in the line table.

In Object Designer, create a new table called Complaint Line with the field Document No.. The Data Type should be Code with Length as 20; again, this should be exactly the same as the No. field on the Complaint Header table. As you may have guessed, these two tables will be related. When you save it, save the table as 50001.

Set up the table relation to the Complaint Header table on the Document No. field. The reason we want...