W
Westley
I played around with the Table Analyzer Wizard. Is there a way to not use the wizard to split the database? I would like to have a few different tables.
Employees (EmployeeNumber, FirstName, LastName, Address, City, State, ZipCode, CellNumber, HomeNumber, BirthDate, HireDate, TerminationDate, Salary, ReferredBy, VacationDay1, VacationNote1, VacationDay2, VacationNote2, VacationDay3, VacationNote3, VacationDay4, VacationNote4, VacationDay5, VacationNote5, VacationDay6, VacationNote6, vacationDay7, VacationNote7, VacationDay8, VacationNote8, VacationDay9, VacationNote9, VacationDay10, VacationNote10, MondayAM, MondayPM, TuesdayAM, TuesdayPM, WednesdayAM, WednesdayPM, ThursdayAM, ThursdayPM, FridayAM, FridayPM, Notes, DateCreated, UserCreated, Date Modified, User Modified, DateLeadsAcquired, LeadsAcquiredAM, LeadsAcquiredPM, LeadNotes)
I would like the primary key to be EmployeeNumber on different tables. How would I do this? how would I create lookup tables? what happens to my original table?
Employees (EmployeeNumber, FirstName, LastName, Address, City, State, ZipCode, CellNumber, HomeNumber, BirthDate, HireDate, TerminationDate, Salary, ReferredBy, VacationDay1, VacationNote1, VacationDay2, VacationNote2, VacationDay3, VacationNote3, VacationDay4, VacationNote4, VacationDay5, VacationNote5, VacationDay6, VacationNote6, vacationDay7, VacationNote7, VacationDay8, VacationNote8, VacationDay9, VacationNote9, VacationDay10, VacationNote10, MondayAM, MondayPM, TuesdayAM, TuesdayPM, WednesdayAM, WednesdayPM, ThursdayAM, ThursdayPM, FridayAM, FridayPM, Notes, DateCreated, UserCreated, Date Modified, User Modified, DateLeadsAcquired, LeadsAcquiredAM, LeadsAcquiredPM, LeadNotes)
I would like the primary key to be EmployeeNumber on different tables. How would I do this? how would I create lookup tables? what happens to my original table?