nomalisation of table (1 Viewer)

[bl0u2011]

I am having a large table like below

Employee_Record
Log
FirstName
Surname
Gender
DOB
LogIntoBuilding
LogOutBuilding

What I want to do is to creat a Employee table like below

ID
FirstName
Surname
Gender
DOB

which will be separated out from Employee_Record table while automatically creating a ID column in Employee_Record which will link to new Employee Table

Does Access has any function that can do that?

Thanks you all

 

[neileg]

I presume your ID will be an autonumber.

Create your new table with the autonumber. Create an append query to add the 4 fields from Employee_Record. Add an EmployeeID field into Employee_Record. Join the old table and new table in a query, using a join between all 4 fields to ensure an identical 1 to 1 match. Make this into an update query and insert the EmployeeID from the new table into the EmployeeID field in Employee_Record. Now delete the 4 duplicated fields from Employee_Record.

 

[bl0u2011]

Thanks

Cheers Mate it work out great!!