Access database questions

I have two tables (appointments and studentinfo).  One of my values in Appointments is a lookup from student info of the following values Student first name, Student last name, and student email. When I create a form for Appointments, and I include this lookup value, it only returns the first value (e.g. student first name) even though I can see all of the other values in the drop down.  There has to be a way to make this show everything in the lookup field.
LVL 1
mjburgardAsked:
Who is Participating?
 
Jeffrey CoachmanConnect With a Mentor MIS LiasonCommented:
You can concatenate all the other fields in the Lookup query, ...Then display the concatenated field:

For example:
SELECT StudentID, StudentFirstName & ", " & StudentLastName & ", " & StudentEmail
FROM tblStudents

Then set the Bound column as 1
Then set the Column width as something like this: 0,3
0
 
mjburgardAuthor Commented:
That works - I now have the issue that the person who designed this setup the email as a hyperlink - which means the email is displaying as blah@whatever.com#mailto:Blah@whatever.com#  any fast solutions for this?
0
 
Jeffrey CoachmanMIS LiasonCommented:
Something like this should work for you:
Database44.mdb
0
Get 10% Off Your First Squarespace Website

Ready to showcase your work, publish content or promote your business online? With Squarespace’s award-winning templates and 24/7 customer service, getting started is simple. Head to Squarespace.com and use offer code ‘EXPERTS’ to get 10% off your first purchase.

 
Jeffrey CoachmanMIS LiasonCommented:
Sorry, ...hold on...
0
 
Jeffrey CoachmanMIS LiasonCommented:
Try this newer sample
Database44.mdb
0
 
mjburgardAuthor Commented:
I wonder if it would be better to separate the email out and create a lookup that references the first studentN and is actually a hyperlink - that would allow people to click and email a record to the student.
0
 
Jeffrey CoachmanMIS LiasonCommented:
Most experts stay away form these email formatted fields, because they can cause problems later on...
Besides, opening up an email by clicking the hyperlink field:
1. Will only work if the end user has Outlook installed as their default email client
2. Might not be possible with your networks security settings
3. Might result in errors if the email is incorrect or invalid

In my opinion, sending out emails should be an administrative function...
Not something that every user of the database should be able to do...

But I leave that up to you...


JeffCoachman
0
 
mjburgardAuthor Commented:
Awesome, quick feedback and it worked like a charm.  Thanks
0
 
Jeffrey CoachmanMIS LiasonCommented:
Thanks
Enjoy your weekend
;-)

Jeff
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.