Duplicate info... AGAIN

[Oscar.Ingalls]

So, here I sit, building a database to track completion of training events and tasks. I have to create a record for each employee based on what area they work in, with training items assigned to employees by what area they work in. Several thousand rows of data when complete I'd guess. I have the tables set up how I think I want them, I have several queries that produce the results I want, but, as I add/edit/delete tasks for each area I need to update the individual record for each employee assigned to that area. I made a macro (by trial and error really) that can update the info, but creates duplicates in the table where tasks are assigned to employees every time I hit run. It's an append query that pulls from the tasks table and loads those tasks to names where the task area and employee area match. I'm very new and am trying to either prevent the query from adding duplicate lines of data or...? Help?

Oz

[Perceptus]

There is a great program for this called "DevTest" and "DevTracK" its not the cheapest thing in the world, but sounds right up your alley. In the even you are not rich, Could you give a diagram of how you are laying out your tables in relationships? You may want to move this another area of the forum, This seems like a design concept then a query issue.

A database diagram would really help. There are soooo many ways to setup tables and queries.

Lets imagine you have the following
tblTasks, tblEmployees, tblWorkArea, tblTrainingItems.

Several thousand rows maybe, if you are doing foriegn keys maybe even more!
Where are the duplicates showing up? What is the code that produces this duplicate?

[Oscar.Ingalls]

Thank you for the response. I have decided to forgo the VBA piece of this until I can learn it. Just going to do manual delete until I have a clue what I'm doing. I can compact and load my DB if you want to review it. I'm sure it's full of silliness since I'm new to this and self taught.