Hi,

I've got a access XP database.
In this DB there are 2 tables:
- CustomerContact (keeps track of all the contacts we've had with a customer)
- Actions (keeps track of all the actions needed to satisfy the customer)

As you can imagine, 1 customer can have multiple entries in CustomerContact, and 1 entry in CustomerContact can result in more than 1 action.

To have a proper form in Access I'm writing a activeX component that displays all the CustomerContact and Actions for a specific customer.

To create this activeX and to fill it with data is no problem.
The problem occurs when trying to add or modify data.
I was thinking of creating a 'dirty' property for each CustomerContact, that can be set to true or false.
Now I want to have a proper connection with the database that allows me to update the record or to create a new record whenever it's needed.

Does anyone have some suggestions on how to sort this problem.

Thanx.