Combobox to add new column

[ChrisLayfield]

I am fairly new and have not found what I need through searches. If you have a link to something that could help, that would be great.

I have a form for a Required Training table. The table contains the Course ID, Course Name, Job Titles. Each Job title is set to a yes/no to indicate if the training course is required or not. There is though an Other category for the job titles. When the check box is marked for the other, it required the user to select the job title or enter the job title into a combo box that appears.

I am trying to build a macro that would then add the job title as a new column to the Required Training table after checking to make sure the job title was not already a column header. I have been trying to learn and use the wizard to build macros for me to facilitate learning, but cannot get it to do this. Thanks for the assistance.

 

[boblarson]

First of all, you should not be doing this. You should not be adding a column for each job title. You should be using a NORMALIZED approach where you would have a junction table which would add a RECORD (not a column) for each job/training combination.

 

[ChrisLayfield]

Thanks, I will have to do some research on junction tables and see if I can get that to work.

I think I will have to move this to tables for further discussion. Thanks Bob.