I'm working on a tracking program for safety classes taken by employees. In my form I have set up a query for SSN field so users can either choose the number from a combo box or they can type in the SSN. When the user does this it will automatically fill in the user name, jobtitle and office (these fields are unbounded to do the search). But once the new information is added to traindate and traintype fields, the user will hit the save record but the fields for User Name, Jobtitle and office does not save in the database and I need it to. How can I have all fields save into the database?

Any help will be appreciated.

You don't need to save those fields in the table. You retrieve them via a join to employee table whenever you need.

It is NEVER a good idea to store redundant data.