Sorry if this is an FAQ, but if I want to add listbox control on a form
attached to a table, say STUDENTS with a field Students.Tutorial, and I
want it to look up valid values for a primary key on a TUTORGROUPS table.
The TutorGroups has an Autonumber Integer Primary Key GroupID, and a
some text fields YearNo giving the year no and Suffix.
How do I set up the List Box to use TutorGroups.GroupID in
Students.Tutorial, but also show TutorGroups.YearNo and
TutorGroups.Suffix to allow the user to select an option that means
something to a human being when using the form?
If there's a pointer to a tutorial or wiki page that will help please
let me know. Thanks in advance for your help.
Cheers,
Ian Hulin
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
