I defined a simple FS to learn, but keep getting the same values for different codes.
Shortly, I have 2 tables, first one (
ReasonID,Reason Description, etc.
MAIN) I enter other unrelated data and
REASONtable into that
MAINtable by the help of FS. So I defined something like that:
When I use this query, I keep getting the same reason description for different reason codes, actually the description of the first data in the REASON table.
Ouery settings : Search By Saved Query - Auto Refresh - When exiting altered column - Column "REASONID "- Refresh regularly
I guess, I have to add or change something in the query, so that I can refer to the <u>activ ReasonID value</u> in the MAIN table and get the descr. for it.
(Sorry if this subject is handled before but I couldn't find anything related in SDN.)