Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all
in table 1 name and code field is re portable data, table 1 is the base table of reportable data
table 2 name and code field is is mixed of reportable and unreportable data.
now i need a list box name called reportabilty in the front end with a value of reportable and unreportable
where if the user select the reportable from list box it shd the reportable names of the table1 and table 2, similiar tot the unreportable
how to do this in the coding
Something like this:
table1:
LOAD
code as repcode,
name
FROM
...somewhere...
;
table2:
LOAD
code,
name,
ADDRSS,
ID,
If(Exists(repcode,code),'Reportable','Non reportable') as Reportablility
FROM
...somewhereelse...
;
DROP TABLE table1;