Displaying a field in a report

Hi simjambra,

Let me make a few assumptions here (and please correct me if I'm wrong):

- the combo box is on a form you use to input data to your student table;
- the combo box row source is from your "separate" course names table;
- the course names table has a primary key;
- the combo box only adds the course name primary key to the student table (as a foriegn key);

All you need to do is build a select query to provide data to your report. The query should include the student table, the course name table, and a join between the two using the primary key / foreign key mentioned above.

The result of the query will enable you to add the "long version" course title to your report.

Cheers,