I have some option boxes and combo boxes that looks up values on a
separate table (i.e. campus table with campusID & campus name fields)
When I choose a selection from the combo box, it puts the information
in a
main table when I do ADD RECORD. Only the campusID (a number) gets
added in
the main table. How can I get the corresponding value displayed on
the table (i.e. campus name) instead of the equivalent campusID (which
is unique).
I want to be able to create a subform & display the actual value the
user sees on the combo box instead of the corresponding number from
the campus table.
Main table Campus Table
========== ============
user campusID
campus name campus name
Main Form
==========
field1: User
field2 (which is a combo box that looks up the campus table): campus
name
Example:
Campus Table:
campusID campus name
========================
1 st. john
2 ucla
3 northwestern
Main Table:
User Campus name
=====================
paul 3
lisa 1
john 1
louie 2
Any ideas would be appreciated. You may email me directly at
pc*******@yahoo.com. Thank you.
Paul