This custom function was brought to my attention the it’s creator, Caleb Miranda. Simple, and when you find a use for it, easy to implement:
This function has the purpose of retrieving a simple value from another table. It always seemed so obvious for me, but I didn’t find it before
The idea is, one provides the field from which the value they desire – fieldDesired –, the field to search from – fieldKey – and the value that the fieldKey has – valueKey
Sample input: RequestSQL(customers::name;customer::CustomerAge;35)
Sample Output: the name of all the customers whose age is 35
I like it!