Btn Click(1st form) to Open 2nd form with 1st form details

[vancey]

Thanks John. Gonna try to work more on it....

 

[vancey]

Hi John,

im back with my normalization of my database. I encountered 2 problems. 1st, It seems that i have overused the indexes on a table, and the error msg "Operation failed. There are too many indexes on table 'tblEmploymentHistory'. Delete some of the indexes and try the operation again.

How do i really go about not overusing the indexes, or have i 'too-normalized' the database? becoz i have many tables with just 1 fields in it.

2nd problem is how do i go about structuring the tables if 1 employee may have 3 designations. I seems to have violated 1NF rules because of my duplication of the same data type 'designation1,2,3' in a table and need some of your advise to how to go about it.

Attached is the relationship of my database for your reference.

Thanks!

 

[John Big Booty]

OK with your DesignationID's and CostCentreID's these should be in junction tables that store both the EmployeeID and the DesignationID/CostCentreID and possibly Start and End dates and possibly a comments field.

 

[vancey]

Hi John,

With reference from the sketch, i think my EmploymentHistory Table acts as a junction table between Employees Table and CostCenter Table already, is it?

Employee
EmployeeID
Surname
FullName
.......

EmploymentHistory
EmployeeID
CostCenterID.......

CostCenter
CostCenterID
CostCenterName

I need to have 3 cost centers for each employee, how do i do it so that no duplication will occur?