Hi,

I am new to Access. I have a form in my producer database for Current Customers. One tab has all the general info, one has the radio show info and I have a third tab for incidents/complaints. I like the set up of this, because it keeps all of the information for each current customer in one place. My issue is with the Incidents/Complaints tab. This tab has information that is pulled from my Incident/Complaints table. What I want to do is be able to add more than one incident for each customer if I need to.

Here's the problem: when I add a new record in my Incidents table for a current customer, it associates a new ID with the new record, even though the name is the same. There is a relationship between the parent (all customers) and child (incidents) tables by ID, so I don't know why this would happen.

I hope this is clear enough for someone to help. Thanks so much!

What are you doing to add a new record to the incident table?

__________________
(RG for short) aka Allan Bunch MS Access MVP - WinXP Pro, Win7 - acXP, ac07
If your issue is resolved...follow this link for directions on how to use the Solved thread tool!
Teaching is not filling a bucket but lighting a fire. Borrowed quote..."Docendo discimus"

Originally, I made a separate Incident Form, so I used that. The form was built so it pulled all the general contact info from the All Customers (parent) table, and then I added the Incident specific fields from the Incident table.

Let me try again. How *exactly* are you currently adding a record to the Incident table? Maybe if you posted your db because it would be very useful to see your tables and how you have them structured.

__________________
(RG for short) aka Allan Bunch MS Access MVP - WinXP Pro, Win7 - acXP, ac07
If your issue is resolved...follow this link for directions on how to use the Solved thread tool!
Teaching is not filling a bucket but lighting a fire. Borrowed quote..."Docendo discimus"