ComboBox derived from 2 datasources

I have a Input ComboBox with the list bound to a sql binding source "bsStaffList" and I want to retreive and save the value from and to the customer binding source bsCustomerDetails - StaffID

Cant seem to work out how to do that. I['ve tried a few combo-nations :) no sucess so far.

Also tried values in  SelectedIndeax and SelectedValue with no sucess.

Can anyone help ?


Me.ipCbCSO.DataSource = "bsStaffList"
        Me.ipCbCSO.DisplayMember = "name"
        Me.ipCbCSO.ValueMember = "bsCustomerDetails - StaffID"  <<- ????

Open in new window

siacomAsked:
Who is Participating?
 
Jorge PaulinoConnect With a Mentor IT Pro/DeveloperCommented:
You cannot do that way!
You have do define the DisplayMember and ValueMember for the DataSource you have defined and not another one.
0
 
siacomAuthor Commented:
so you cant use 2 datasources ? 1 for dispolay and 1 for value ?
0
 
Jorge PaulinoIT Pro/DeveloperCommented:
No, you have to join the information in only one datasource
0
 
siacomAuthor Commented:
hmmm.... not something I want to do right now... might as well not have a combo.
thanks anyway.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.