I described a question/problem here (viewtopic.php?p=15988#p15988) which results in this request:
It would be great, if we could use placeholders in custom lookup queries which are filled at runtime. These placeholders could (also) be fieldnames.
Example:
I am working on a record which has a field "fieldname_group".
In a lookup for that record, with for example
Code: Select all
SELECT * FROM tableX
Code: Select all
SELECT * FROM tableX WHERE group='group A'
If I am working on a record of group B, the SQL should look like
Code: Select all
SELECT * FROM tableX WHERE group='group B'
Thus, I can imagine setting up the custom query something like this
Code: Select all
SELECT * FROM tableX WHERE group='{fieldname_group}'
makes sense? Hope so.
Olaf