Damn, ADO.net next time.

I've written my own code that uses the where statement against the database for filtering. The Dataview's version was too limited. If I remember correctly it can only be used on key or indexed fields, you *can't* do a sort on any field, and my users expect that because they could do it in MS Access.

OK, but here is the new part for me.

If I have Textboxes that are all on one form with data from two different tables that have a join (two columns related to each other). What do I do? I'm playing with it now. I had my data navigation bar (next, prev, last, first) custom bar working fine with dataview. But if I want the position to change on let's say, Last name field in a table, I simple change the .position. However, now I need the employee Number for the Last Name, which is in another Table. I've got the relation defined already. But, the dataview I have doesn't even contain the name of my employee number field because it is in a related table! So I'm a bit stuck.

If I change the BindingContext.Position of on table that is related to another, will they both move at the same time? I hope so...

Hope I haven't completely confused you.