Type of relationship in Access and setting primary keys...

[njnewuser]

Hi,


You guys have been awesome. I think I am starting to get the hang of this....the only thing I can't figure out is how to get rid of the duplicate employees in the Employee tables. They are duped because of the import from the Excel spreadsheet (same employee taking multiples classes) and/or originally I had set the relationships wrong and I thought that was doing it ( I had EmployeeID PK set to Class Schedule ID PK and now I know that was wrong.)
Is the best way to run a delete query on tblEmployees to deal with this or is there another way?

http://office.microsoft.com/en-us/ac...010341696.aspx

Does this look better?

[June7]

Is the EmployeeID_PK an autonumber field? Are there already related child records?

[njnewuser]

Hi. EmployeeID_PK is an autonumber field.

When I look under "Insert Subdatasheet" it says both EmployeeID_FK under both Link Child Fields and Link Master Fields.

I tried to change LName, FName under Field Field Properties Indexing to Yes (No Duplicates) thinking that would help (it was previously set to no) but when I tried to save the table I got this message: "The changes you requested to the tables were not successful because they would create duplicate values in the index, primary key or relationship. Change the data in the field or fields that contain duplicate data, remove the index , or redefine the index to permit duplicate entries, and try again."

[June7]

If there are no dependent records, then just delete the duplicate employee records from tblEmployees. How many employees are there?

Then set Indexing to Yes(No duplicates).

If there are dependent records (classes?) then this gets a little complicated.

[recyan]

Just a thought,
Do not know your basis for Unique Employee in the table "tblEmployees". If it is just FirstName & LastName, perhaps you should go in for one/more additional field/s, to make it unique.

Thanks