Addine new records to multiple tables

[ibbledibble]

Hi

I think I need to use a query to resolve this problem which is why I've posted here.

I need to add new records to my database involving fields from three different tables. The tables are called Customers, Incidents and Outcomes. Customers has a one-to-many relationship with Incidents, which in turn has a one-to-many relationship with Outcomes.

Currently I have multiple forms related to each table that the user can open in turn and add new data. However, this is becoming a long-winded way for entering certain types of enquiry to our service. Therefore I wanted to create one form that contains fields from the three different tables and add new records through this form. This will automatically place the new data in the corresponding tables relating to the fields. I presume I either need an append query or update query but have no idea which.

can anyone please help?

Thanks

 

[neileg]

Sounds like you need a form/subform setup. The subform wizard will link your tables using the parent/child relationships.

 

[ibbledibble]

Thanks

I think that's what I currently have, although they are linked separate forms. I was wondering if it could be done designing a form from a query that pulls all the data together?

 

[neileg]

Separate forms don't allow the parent child lnks to be maintained automatically, you'd have to code it in VBA. You could use a combined query, but you'll still need two subforms for your incidents and outcomes.