Well here is my problem.

I have a datagrid that is bound to the following rates table:

ID            Autonumber
VendorID      Number       ForeignKey
CourseID      Number       ForeignKey
EffectiveDate Date
ExpiryDate    Date
Min           Number
Max           Number
Price         Currency
UnitID        Number       ForeignKey (Used to lookup Unit Text)

These are my Requirements:
1. All 4 ID Fields should be invisible to the user.
2. A Column should be added to the datagrid that displays the UnitText and can be set using a drop down combobox.
3. Both date columns should use the datetime Picker to set the date
4. VendorID and CourseID should be set in code with values that are allready on the form (ie. combobox itemdata)
5. The User can edit, add, and delete records easily.

The problem is that whenever I try to code this it goes FUBAR.

I have to use a SQL query to set the VendorID and CourseID after they are originally written to the DB with 0's.

I keep getting a 'Cannot update record because the values may have changed' error after doing some adds and edits.

Basically what I would like is a solid example on how to do this with the above requirements shown. I realize this doesn't sound difficult but Events aren't firing when I would expect and the events I need to code this the way I want to never exits. Plz Help I am going crazy over here.