Hi,
I am not sure if the correct format on my Subject line but I am having
problem that I find very difficult sleep last 2 days.

I have a CustomerTable, ProductTable and OrderTable in my SQL Server 2000.

I create and Order Form that I can enter new order or search order by Product,
Customer and Price.
The CustomerTable and ProductTable Forms works fine. In the OrderTable form
is about 600 x 600

And the first 300 from above i place the DataSource details controls and the
bottom of the form I place the Datagrid.

The searching the ordertables was great but I am having problem inserting the
new order.
In the CustomerID and ProductID textBoxes I convert to them as ComboBoxes. So
that I don't want to see the ID numbers but I wanted to see the CustomerName
and Productname.

This part I couldn't make it to work to show the in 2 comboboxes the
respectivly:

Not CustomerId -----> but CustomerName
Not ProductId --------> but Productname.

I also want to use Bindingnavihator Add button so in the both comboboxes
fills with Customername and Productname but when use the BindingNavigator
save button I want to save their ID number.

I guess I jump to erly to ADO.NET 2.0 so I couldn't find any example how to
achive this in VB.NET 2005

So, does anyone have any good example how to solve this problem? Or I also
like to see any good article that demonstrates how to achive this problem in
a easy way. I thought jumping the ADO.NET 2.0 was reduce my coding time that
I had previously speend many hours to achive it withj early ADO.NET.

I thank you for reading mu post.

Rgds,
GC