Hello all,
At the moment I have two unrelated (atleast within the db) tables. One is "Employees" the second is "Instructors". All of my "instructors" are also employees. Both tables have the same type of info (ie. firstname, lastname, employee-number, etc.) Is there a way to add a field to my employee table that identifies my instructors, and then based on that list, be able to do the things that the "instructors" table is currently doing elseware in the database.
At the moment I have two unrelated (atleast within the db) tables. One is "Employees" the second is "Instructors". All of my "instructors" are also employees. Both tables have the same type of info (ie. firstname, lastname, employee-number, etc.) Is there a way to add a field to my employee table that identifies my instructors, and then based on that list, be able to do the things that the "instructors" table is currently doing elseware in the database.