I have created a form which has two "Site" mmdropdownlists. One of these lists will show all of the items in the Site table. The other needs to see only a subset of the table.
I know SQL, so I don't need to get into SQL commands. What I am looking for is, how do I do this in MM .NET?
e.g. mmDropDownList properties...
mmDropDownList SiteObject1
BindingSource = 'Site'
BindingSourceDisplayMember = 'description'
BindingSourceValueMember = 'code'
BindintType = 'TwoWay'
BindingValueSource = 'Orders'
BindingValueSourceMember = 'Site' <--- field 1
----------------------------------------
mmDropDownList SiteObject2
BindingSource = 'Site'
BindingSourceDisplayMember = 'description'
BindingSourceValueMember = 'code'
BindintType = 'TwoWay'
BindingValueSource = 'Orders'
BindingValueSourceMember = 'Temp_Site' <--- field 2
As you can see, the result will be the same. My system needs to show in SiteObject2 all of the items in Site which does not have the word "Office" in it.
It is obvious that a second table would work, but there must be a way to handle this in MM .NET without making a second table. I have looked at creating a view, but when you select the BindingSource, the view is not allowed.
Any suggestions???