AnsweredAssumed Answered

How to match field value to multiple field values

Question asked by DeShawnJackson on Feb 17, 2011

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

Outcomes