Access 2002: Using a table column as a combo box

[TheElephantMan]

Hi, all.

I have two tables that resemble the following:

PROJECTS
project_id|project_name
----------|------------
1 |fix mainframe
2 |rebuild warp drive

CHANGES
project_id|change_number|change_details
----------|-------------|--------------
1 |1 |drained coolant
1 |2 |updated drivers
1 |3 |loaded tapes
2 |1 |mended crystals
2 |2 |cleared conduits

I am trying to make a form that allows me to enter new CHANGES, using the list of PROJECTS as a combo box to decide the value that will go in the project_id field of CHANGES.

Using the Wizard, I've created a form that uses the two tables, and includes the project_name field from PROJECTS, and all of the fields from CHANGES. I've placed project_name on the form as a combo box, but when I put an entry in it, it creates a new value in the CHANGES table.

Is it possible to use the project_name field in this fashion? Can PROJECTS.project_name be linked to CHANGES.project_id like this?

Thank you very much for the help!

TEM

 

[PHV]

You may consider a mainform for PROJECTS and a continuous subform for CHANGES.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886