ValueLists using ExecuteSQL

Discussion created by vince.menanno on Oct 4, 2012
Latest reply on Oct 8, 2012 by nickchapin

When I first learned FM 7 one of the core concepts of working in this version and even in FM 12 is this notion of context.


And context is also very important to understand when you are defining value lists. So you define a value list much like you would a relationship in that you look from the originating table occurrence.


Problem is if you want to reuse the same set of values that you defined in one place in another table. You'll have to attach another table occurrence just to get the same list of values.


It would be great if there was a 4th option in defining value lists via a SQL statement. And it did not matter what you attached this value list. Much like a list a static values.


The SQL statement would evaluate always from a specified table occurrence. This would be another place where one could reduce the number of table occurrences that one would need to maintain.