sql - ComboBox for values in different rows -

i need combo box in formone shows values tableone based on value: id. below illustrates sample of tableone:

id          name           adress 1 1 1           tom        1                           streetname 1     2 2 2           steve  2                           streetname2  2 

need combo box , related text field showing relevant information based on id record.

does have clever solution ?

you can use query source:

select      tableone.id,      tableone_1.name,      tableone_2.address      (tableone  left join      tableone tableone_1          on tableone.id = tableone_1.id)  left join      tableone tableone_2          on tableone.id = tableone_2.id group      tableone.id,      tableone_1.name,      tableone_2.address having      tableone_1.name not null      ,      tableone_2.address not null;