pk/fk means primary key/foreign key
Review
http://office.microsoft.com/en-us/ac...010098674.aspx
What is the data structure? Are students unique in CompanyStudents (is there only one record per student)?
To INSERT only one record don't use SELECT in this case because all the data for insertion is on the form:
INSERT INTO CompanyStudents ([First Name], [Last Name], Gender, Title, Job_Number )
VALUES([Forms]![CompanyEnterDB]![FName], [Forms]![CompanyEnterDB]![Lname], [Forms]![CompanyEnterDB]![Gt], [Forms]![CompanyEnterDB]![ttl], [Forms]![CompanyEnterDB]![Job_Number]);
You will have to refresh the form afterward for the new record to display.