add fields to table using combo box

[mikeder]

I have a problem adding fields to a table using a combo box.

I have a bunch of project files that each need to be assigned a project manager. There are only 10 possible project managers. I want to enable it so that I have a combo box where I can select a project manager for each project file.

Eventually i want to be able to report of this dbase so that if i can show all projects under a specific project manager.

I have a projectmanger table with three fields F_Name, L_Name, ID

On the project_file table i have ID, File_Num

please help!

 

[IfButOnly]

Mikedr, I'm not sure which direction you are going - adding a project manager to a project, or adding a project to a project manager. Let's that the first case

Your project_file table has a field ID - I assume this is project_manager_ID and that file_num is the project key. If not, you need to add a project_manager_ID to the project_file.

Set your combo box from a select list of the project_manager table, binding the project_manager_ID column. The control source of the combo box should be project_manager_ID from the project_file table.

Hope this helps..

 

[mikeder]

Thanks for your reply. I think i should be more specific regarding my problem.

I am trying to add a Project Manager to a Project File via a combo box.

I have a main form called CLIENT_COMPANY (name of company, address info, url etc) and a subform called PROJECTS which contains my project file number and related information (i.e. file number, year, work description etc). Inside this PROJECTS subform I have created another subform that contains Client Contact information and Project Managers. This subform gets it's information from a select query that brings information from 2 tables together (Client_Contact & Project_Manager).

What I want to do is create the combo box that will attach a project manager to the PROJECTS subform.

I have a Table in my Projects Table Called Project_Manager_ID. I also have another table called Project_Manager with unique IDs. The ID field on the Project_Manager table is related to the Project_Manger_ID in the Projects table in a one-many relationship.

Is this clearer?

 

[IfButOnly]

I think I've got it.

You have a main form CLIENT_COMPANY, with a subform PROJECTS. PROJECTS has a subform, say CONTACT_INFO.

From your Project Manager Combo box (say cboPM) in CONTACT_INFO, you want to select a Project Manager and update a field in PROJECTS.

If that's the case, on the after Update event of cboPM

Forms![CLIENT_COMPANY]![PROJECTS]!txtProjectManager = Me!cboPM

are we close?