Got most of the db created as well as the form however I am getting stuck at it automatically knowing the ID as the only thing being displayed is the Department name. Therefore I need to find some way for it to find out the ID and then populate it into other areas from there.
What kind of control are you using to select the department? If it's a combo or list box, you can use column count and column widths to display or hide certain data.
ie: A combo box with department_id and department name could be made to display only the department name, but have the department id as its true value by setting columncount = 2, and columnwidths = 0";1" (also make sure column 1 is your "bound column", that's the one that gets looked at when you cal cboMyCombo.value)