select single with a condition

[Dror]

Hi,
As far as I know , if I have a User Table with (id , type , name) and I want to reference it
in another table named Workers (user_id , company_name) using a select_single mode , I cannot do it with a condition (e.g. type=3) only for the whole table

Is that correct?
What would be the option of I have a lot of users in my users table , with various types (that represent senior users , admin users , power user , etc) and I want to reference only a sub-set (based on type) of this users on another table using a select single with primary key table /id / field ?

Thanks

 

[eugenio]

Hi Dror,
that feature is in the to do list but at the moment it is not possible to filter the records as you would like to do

 

[DebbieS]

Eugenio is correct, this is not something native within the program.

There is a hack from a while ago that you might want to look into:
http://www.dadabik.org/forum/read.php?1,5492,5492#msg-5492

Line numbers, etc., will need to be ignored as this is for an earlier version of the program, however, it may be of some help to you.