Centauri117
Programmer
I have two tables the first table holds records about customers. The second table has records about the customers history. I am trying to use a combo box to pull up a record about a customer. When a customer is selected I need the sub form, or second table, to list all the records about that customer. My problem is that the I need to be able to delete a record about a customer on the main table and have all the histories deleted also. This means my customer field needs to be indexed with the option of NO duplicates.
So that I can have cascading deletion. When I put the index on the field and try to use the combo box it gives the Error 2105 and says "You cant go to specfied record." "You may be at the end of the recordset." After that if I even try to close the form it gives another error: "Update or cancelUpdate without addnew or edit."
So that I can have cascading deletion. When I put the index on the field and try to use the combo box it gives the Error 2105 and says "You cant go to specfied record." "You may be at the end of the recordset." After that if I even try to close the form it gives another error: "Update or cancelUpdate without addnew or edit."
