Validate field values using a connection table

  1. Create validation tables for the dependent field.
  2. Create a connection table
  3. Specify the tables in the field profile for the dependent field:
    1. Create or edit the dependent field (for example Size) in your invoice profile.
    2. Select the Table validation settings and select the name of the connection table next to Connect to in the Connection table group box.
    3. Select the name of the via field (for example Product) (the controlling field) next to Via field.
    4. Select Connection 1 to indicate that you typed the names of the other tables in the Connection 1 column of the table.
    5. Save the invoice profile.