reportable vs non reportable

[manoranjan_d]

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

[Gysbert_Wassenaar]

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;