Re: FORMS question

From: Marc Legardeur <mlegardeur_at_lc2m.fr>
Date: Tue, 31 Aug 1999 17:04:01 +0200
Message-ID: <7qgqq9$pm5$1_at_oceanite.cybercable.fr>


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.
Received on Tue Aug 31 1999 - 17:04:01 CEST

Original text of this message