display of combo box

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hihi

I use combo box for a field like Students. Where i hav Student ID and their respective names
The data is saved as their ID. How can i make it to show their names instead of ID when i run a query?

Any help is appreciated!
Thanx!! =)
 
Hihi,

I use combo box for a field like Students. Where i hav Student ID and their respective names.
The data is saved as their ID. How can i make it to show their names instead of ID when i run a query??

Any help is appreciated!!
Thanx!! =)
Click to expand...

Add the Student table to the query. Make sure the relationship is
shown between all the tables.
Then, instead of using the combo box in the query, use the
[StudentName] field.
 
Back
Top