Re: FORMS question

Marc Legardeur wrote:
>
> Even if i'm not an expert, I think that you have a many to many relation
> which can be formalized in two master and one detail relation
>
> <daud11_at_hotmail.com> a écrit dans le message :
> 7qdk8c$da8$1_at_nnrp1.deja.com...
> > Hi
> >
> > I am using Dev2000 v2.1.
> > I have 2 master tables:
> >
> > 1) student
> > student_id
> > student_name
> >
> > 2) courses
> > course_id
> > course_name
> >
> > I also have a table that stores that courses taken by each student.
> >
> > 3) student_courses_taken
> > student_id
> > course_id
> >
> > I would like to create a form to allow user to add/edit/delete the
> > contents of this table but I am not sure how. I want the student table
> > to be a master table and create a detail block for the courses table.
> > However, I am not able to display the course name in my detail block. I
> > am only able to display the course id. I guess I need to create another
> > master table to link to that detail block but not sure how. Hope to get
> > some detail help from this forum because I am a beginner in Oracle D2K.
> >
> > Thanks
> > Daud
> >
> >
> > Sent via Deja.com http://www.deja.com/
> > Share what you know. Learn what you don't.

Why don't you have a pop-list that is populated by a record group which lists all courses available. Received on Wed Sep 01 1999 - 16:39:00 CEST