Binding and things on ComboBox

[Merlin]

Hey All,

I want to be able to in a ComboBox on a normal WinForm select it and pull a
list of all Sites from my Sites feild in my Sites Table, however my SitesID
Feild in ArcUsers Table is a Lookup to the Sites Feild in my Sites Table.

A Colleuge has just told me he thinks its something to do with binding(s)

My tables are as follows:

ARCUSERSTABLE:

ARCUSERSID(PrimaryKey)
Name
BOMID
TILLID
SitesTABLE:
SITEID ------ This has a Relationship to and looks up all feilds in
Sitename --- SITEID(PrimaryKey)

SITENAME

CONTACT

I created for my Dataset the join etc etc all ok, seems to work ok, now i
just need to be able to have a combobox to select the site and update the
siteID in my Arcuserstable.

If i select my datasource as SiteID in my ArcirisUsers table i get many
repitions of the data as it is looking up all the feilds in SiteID of the
arcuserstable.

Many thanks for your help
Merlin

 

[Merlin]

Having look at this i think i need to do something like:

combobox1.DataBindings.Add("Text", dsArcirisUsers, ArcirisUsers.SiteName")

When i fill the dataset or am i barking up the wrong tree?

Ta
Merlin