View Single Post
  #1  
Old December 5th, 2005, 12:46 PM posted to microsoft.public.access.forms
external usenet poster
 
Posts: n/a
Default How do i add multiple records to table from 1 form entry?

I'm currently creating a database that assigns problems to people that could
solve them. I have a table called "employees" and one called "incident
catagories". Since one incident may be solved by multiple people and since
one person could solve multiple problems, the database is a many-to-many.
Employees table contains a a unique ID called Cont ID. The Incident
Catagories table contains a unique ID (for each incident) called IncCatID. To
link the two tables to make the many-to-many relationship another table was
made, where the data had to be inputted manually. This data assigned
incidents to people and contained both the IncCatID and ContID.

To make the database more versatile, a form was made that can add/edit
employees in the employees table. The problem now is that a form or sub form
is required to add or edit a new or current employees responsibility i.e.
match the employee to the incident.

I seriously require help in this matter urgently... I have tried almost
everything i can think of.