Steve (a.k.a. ssanfu) kindly informed me on a previous post (https://www.accessforums.net/showthread.php?t=75955) that my structure lacked normalization. After, reading the material he provided I'm back at my attempt of normalized data. If one of you gurus could take a peak at the attached db and provide feedback on what areas still need work I'd greatly appreciate it. Also, if I could get a bit of help how I can implement my tbl_PersonnelCompPayGrade_J. It's meant to ensure that there is only one of each paygrade in each component... I just can't seem to figure out the best way to put it in place.
[ATTACH]Table Structures[/ATTACH]