AnsweredAssumed Answered

Help needed with "Drop-down list" and "Value Lists"

Question asked by burghfan on Sep 15, 2016
Latest reply on Sep 15, 2016 by burghfan

In our "Customers" Table there is a field labelled "CustomerType" for selecting the the type of "Customer". This field is Drop-down list with the following selections; “Enduser”, “Contractor” and “Engineer”

 

The Value Lists we created are;

 

All Contractors - Use Values from Field - Both from the “Customer Table” left side = ID_Customer right side = Customer_Contractor

 

All Engineers - Use Values from Field - Both from the “Customer Table” left side = ID_Customer right side = Customer_Engineer

 

All End Users - Use Values from Field - Both from the “Customer Table” left side = ID_Customer right side = Customer_Enduser

 

I use Calculated Fields as follows

 

Customer_Contractor = Calculation - If ( CustomerType = "Contractor" ; Customer & " - " & CustomerType )

 

Customer_Enduser = Calculation - If ( CustomerType = “Enduser" ; Customer & " - " & CustomerType )

 

Customer_Engineer = Calculation - If ( CustomerType = “Engineer" ; Customer & " - " & CustomerType )

 

The result is a Value List that separates our customer correctly but displays them as follows in those lists;

 

Contractors List displays a company as “ABC Construction - Contractor”

 

Engineer List displays a company as "XYZ Consultants - Engineer”

 

Enduser List displays a company as  “123 Consumer - Enduser”

 

The questions I have are.

 

1. Is there a better way to generate a specific “Customer List” by CustomerType

 

2. Or is there a way to remove the “ - Contractor” or “ - Engineer” or “ - Enduser” from my Value List?

 

The result displays properly in the “Customer” field I just would like to remove the extra baggage in the value list if possible.

 

Help would be appreciated.

Outcomes