[DREON]

hi to all masters,

 

i have 1 two tables

 

1. list

with columns:

   id  |  lname    | fname

   1   |     cruz    |     robert

   2   |    marq    |    don

 

2. requirements

 

with columns:

 

id | lname (related to list table)  | fname (related to list table)| clearance

1                 1                                                       1                            yes

 

on my requirements gc grid view i can see all the from the list table that have submitted there requirements.- i solved this using relation.

 

example view:

 

    id   | lname |  fname  |   clearance

    1      cruz       robert            yes

 

 

now my question is: on my list table how can i get the name not sumbitted to requirements table.

 

[davidoster]

Why don't you have a joined column with {lname fname}? This way you won't need to ask for the name also!