Table/Form Issue

[ginap]

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!

[RuralGuy]

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

[ginap]

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.

[RuralGuy]

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.