combo box problem

[dcnick]

I am trying to use a combo box to store a value in a table from a form. The combo box shows the following:

Plan #
Plan Description

I used the combo box wizard to store Plan Description in my table tblPlan.PlanDescription, and I set Bound Column to 1. However, it stores Plan # instead of Plan Description.

Am I missing something? Any help is appreciated.

Thanks

 

[DBL]

You should save the Plan# to the base table because that's the unique identifier and probably your primary key field. It saves space too, saving the plan number rather than the description ever time. The fact that it's the number that gets saved isn't a problem because you will always view the description on the form and reports. This is good database design.

 

[dcnick]

The Plan # is already saved as another field in the database. For required reports, I also need to store the corresponding description. Plan # and Description are "corporate visions" that will be tied to multiple Projects in the database. So, fields in my base table, tblProjects, include:

Plan #
Plan Description
Project ID (Primary Key)
Project Title

Thanks

 

[dcnick]

That did it. I am obviuosly still a beginner when it comes to Access programming and forget to utilize the Relationships screen.

Thanks for your help