• So if I understand you correctly instead of having 3 columns in the Job_Requisitions table, RequisitionNumber, JobID, and LocationID , you would have a 4th column being the JobRequestID which would be a foreign key off the Job_Request tables Primary Key.

    I will keep my naming convention but thanks for the thought on calling them key instead of ID