On 5/21/2015 9:51 AM, Suresh Raja
wrote:
it sounds like you have a weak grasp of delational database design I would have a single Employee table, with employee ID as the primary key, and any other attributes which are common to all employees, then I would have other tables which contain information about specific employee types or groups, these other tables could have their own primary key, but would reference the Employee table EmployeeID field for the common employee attributes. -- john r pierce, recycling bits in santa cruz |