AnsweredAssumed Answered

Populate Value list with a calculated selection?

Question asked by tkemmere on Dec 3, 2015
Latest reply on Aug 14, 2016 by GeertThijs

Dear all,

 

I wonder: Can I populate a Value list with a calculated selection of a field in a table? And how?

 

I have a table with companies. Each of them have a status. Like:

  • Supplier
  • Prospect
  • Customer type A
  • Customer type B
  • Competitor
  • Etc.

 

Some prospects currently work with a competitor. For them I would like to set up a field "Works with..." and then a drop-down that only shows competitors, not suppliers, customers etc. so it can be easily selected. Hence the question, can I populate a Value list with a calculated selection of a field in a table?

 

I have no need for a separate (related) table. In fact, I wouldn't want that cause competitors are also companies with all their respective fields, i.e. the same. But if that would be the only way to go, so be it.

 

Is there someone willing to help me out on this?

Thanks for the help. Thomas.

Outcomes