PdfPrep.com

What should you do?

HOTSPOT

You need to create the new table for the vendor exclusion list.

What should you do? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.

Answer:

Explanation:

Scenario: You must develop a new solution to maintain a Vendor exclusion list for each customer and item combination.

The solution must meet the following requirements:

✑ Isolate all new vendor exclusion codes as a new assembly by creating a table named VendExclusions.

✑ Create an index for the table named PrimaryIdx that uses the following fields: CustAccount, ItemId, VendAccount.

✑ Ensure that users can open the Vendor Exclusion list report from the customer master form. The list must display the customer account, Item ID, and Vendor account fields.

✑ Maintain referential integrity with other tables.

Box 1: a table extension for Vendors and relation for the Vendor exclusions

Box 2: RelationShip Type

Exit mobile version