I’m stuck with the following:
I have a table where I keep all the many to many records for course data, students and dates.
1.- On one screen I make a query for each course to know the dates it has been given. Here the first doubt is: In the table I mentioned previusly . Since I register from many to many, the date of the course will be repeated for as many students as are registered in the same one, how can I make you bring me only one date instead of as many as students are registered?
2.- By date, I want to consult the people who have attended the course, this has already been done, but since I only bring the data from the list of the consultation, the information that I need to present does not appear in the result of the consultation.How can I bring these values ? in the screen mentioned in point 1, which is where I make the consultation, I don’t have them, because it is the result of the consultation of a combobox reflected in a simple list, how can I bring to the screen and not appear the values that I need to pass to present the results of the detail?
Many thanks for your help!!