Example of a value list that includes only related field values
1. For more information, see About self-joining relationships. Defining a self-join relationship creates another occurrence of the Products table in the Relationships graph (referred to here as the Products 2 table).
3. In Layout mode, add the Category and Item Name fields from the Products table to your layout.For more information, see Placing and removing fields on a layout. If you want to create multiple line items on an invoice, you can add the Category and Item Name fields to a portal.