?
Solved

Form for retrieving related records

Posted on 2014-11-28
4
Medium Priority
?
114 Views
Last Modified: 2014-11-28
I created a database to manage my students.  I created a query from this table as a lookup for the students' names, which also retrieves the Student ID.  I have a separate table for tracking attendance.  This table includes the student ID and date/time of the class only.  I'd like to create a form that:

has a drop-down box to select the student
then, using the student, ID, shows (in a subform) all of the classes that student has attended.
0
Comment
Question by:BBlu
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
4 Comments
 
LVL 7

Accepted Solution

by:
Camillia earned 2000 total points
ID: 40471284
1, Bind your first query to a dropdownlist.
2. Have selectedindexchanged event on the dropdown with Autopostback set to true. For example,called xyz
3. Pass the Student Id to the event in #2. Query the database (you have the attendance table) and bring back the data.
4. Bind the data to a listview or gridview

I'm assuming you're using Web Forms (ASP.Net)
0
 

Author Comment

by:BBlu
ID: 40471286
I'm using MS Access (desktop).
0
 
LVL 7

Expert Comment

by:Camillia
ID: 40471291
That's the database. What will you use to develop the application/front end/website?
0
 

Author Comment

by:BBlu
ID: 40471293
I was able to get it to work.  Thanks, Camilla.  
Here's what  I did:
I created a blank form, then added a combo box that the row source as the student table.  I then used the Insert SubForm query wizard to add a box for the attendance.  It automatically asked which field linked the two.  Thanks, again.
0

Featured Post

On Demand Webinar: Networking for the Cloud Era

Did you know SD-WANs can improve network connectivity? Check out this webinar to learn how an SD-WAN simplified, one-click tool can help you migrate and manage data in the cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

The canonical version of this article is on my web site here: http://iconoun.com/articles/collisions/ A companion presentation is available here: http://iconoun.com/articles/collisions/Unicode_Presentation.pdf
Having trouble getting your hands on Dynamics 365 Field Service or Project Service trial? Worry No More!!!
The viewer will learn how to simulate a series of sales calls dependent on a single skill level and learn how to simulate a series of sales calls dependent on two skill levels. Simulating Independent Sales Calls: Enter .75 into cell C2 – “skill leve…
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question