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:
- Customer type A
- Customer type B
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.