In my query I am pulling the studentid and studentname from the first table, then from the second table I am pulling the teachersname and classname. The query does what I need it to do however it shows the autonumbers assigned to teachername and the classname. Is there a way to show the teachers name and the classname. In the forms this information is picked with a combo box (we have over 100 courses to choose from). Thanks!
If you are seeing the AutoNumber in the Combo Box you didn't shrink the id field -- hide it -- when you set
up your Combo. You might want to watch the Relational Combo video again. That shows you how to combine last name and first name and have it display in the combo. Same theory to combine teacher and class.
You might also want to consider the Cascade video.
If you had cascading Combo Boxes you could pick the teacher then only show that teachers classes or vice versa
choose the class then pick the teacher. Just depends on what is most convenient for you.
Scott Axton
@Reply 4 years ago
You could edit the properties and change the widths of the fields in the combo if you felt comfortable but it's really just as easy to create it fresh.
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Access Beginner 5.
