I am using the DefaultView for the controls on my form. This works well, as I set the BindingValueSourceMember to tableName.DefaultView.fieldName. All works well for most controls.

I am adding a mmPicker to the form. When I use the DefaultView, I get an error when I trigger the picker: "Column 'Inventory.DefaultView.RelativeInventoryFK' does not belong to table Inventory."

If I remove the 'Inventory.DefaultView' and use the table, the control works and saves the data - except it's to the record indicated by the base table and not the row currently selected in the DefaultView.

Any ideas what I'm doing wrong?

Thanks,
Jeff