Gustav, you're probably going to want a third table: EmployeeDeptHistory ================= id employee_id department_id transfer_date
Add a field attribute in the employee table that references this history. -- Jeff Bauer Rubicon, Inc. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Django users" group. To post to this group, send email to django-users@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/django-users?hl=en -~----------~----~----~----~------~----~------~--~---