0 Replies Latest reply on Feb 17, 2011 4:21 AM by DeShawnJackson

    How to match field value to multiple field values

    DeShawnJackson

      Title

      How to match field value to multiple field values

      Post

      Scenario: 

      A portal that will show orders where the contact is either the supplier, bill to, or ship to contact.

      *Your portal will show all orders that the contact is related to, whether the contact was the supplier, bill to, or ship to contact.


      1. Create the following fields:

      Contacts Table:

      k_Contact ID (auto-enter serial; can't modify field)

       

      Orders Table:

      Supplier ID (number field)

      Bill To ID (number field)

      Ship To ID (number field)

      k_Contact IDs (Calculation Number: List( Supplier ID; Bill To ID; Ship To ID )*

      *Note: Supplier ID, Bill To ID, and Ship To ID are fields on the Order table layout that represent the Contact ID selected from the pop-up menus in step #3 below


       2. Create a value list:

      "All Contacts"

      Contacts::k_Contact ID and Contacts::Full Name

      All values

      Show only Second Field

       

      3. Create pop-up menus on Orders layout:

      Create pop-up menu: Specify Field: Supplier ID - Value List: All Contacts

      Create pop-up menu: Specify Field: Bill To ID - Value List: All Contacts

      Create pop-up menu: Specify Field: Bill To ID - Value List: All Contacts

       

      4. Create the following relationship:

      Contacts Orders

      k_Contact ID   =   k_Contact IDs