I have a report table, let's call it "PMT_APPROVAL_REPORT"
as usual, it contains APP_NUMBER and a textfield "Approval title"
I want to use 2 suggest control from that source, which is:
if case number suggest control has selected, approval title suggest control autofield based on APP_NUMBER(case number value) and vice versa
the query is:
SELECT APP_NUMBER, APP_NUMBER FROM PMT_APPROVAL_REPORT WHERE APP_NUMBER = @@ref_case_number;
I know suggestion control works without
that's all I can tell, I hope it's clear so it will be solved soon...