Question1... why do you name your tables l_like t_this ??
Question2... what has r_rights got to do with it? Seems completely unaffected by this modification to me.
Steps to upgrade imo are:
0. Make a backup!
1. Create Card (c_cards) table.
2. Copy the CardExpireDate, CardIssueDate and Details fields to the new table. Create a new EmployeeID field in the new table.
3. Relate the Employee and Cards tables.
4. Use an append query to append CardExpireDate, CardIssueDate, Details and EmployeeID from your Employee table into the Card table.
5. Check everything is ok.
6. Delete the CardExpireDate, CardIssueDate and Details fields from your Employee table.
r_rights is a cross table for permissions.. every card maybe have one or more permission areas associated with it.. r_rights is the very important table! and the problem is to relate this table to the new Cards table so that not every employee will have one or more area permissions but every CARD will have one or more area permissions .otherwise of cuz i can copy those fields and it would be ok
Ok so if the r_rights table needs to be related to c_cards instead of e_employees, you'll need to:
0. Take a backup!
1. Do what I said in my previous post. At this point every e_employee should have ONE c_card.
2. Rename r_rights.EmployeeID to CardID.
3. Create a query that gets all the r_rights entries with all fields. Relate it to your c_cards table (r_rights.CardID to c_card.EmployeeID).
4. Change the query to an update query, and update the r_rights.CardID field to c_card.CardID.
5. Run the query.
6. Delete the relationship between r_rights and e_employees.
7. Create the relationship between r_rights and c_cards.
8. Check the results.
I hope this works for you, I've created the list in my head and it's late. Always do step ZERO!!! :P
I'd still like to know why you name your tables l_like t_this!