Re: FORMS question

daud11_at_hotmail.com wrote:
>
> 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.

Nope. You have to use POST-QUERY trigger to select course name into appropriated display field of detail block. Two blocks are enough.

Hope this helps.

> 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.

-- 
Valeri Sorokine
ProSoft, Russia, Moscow, Information Systems Division
Phone: +7 (095) 234 0636 (6 lines) FAX: +7 (095) 234 0640
E-mail: vsorokin_at_dd.ru OR vsorokin_at_prosoft.ru
http://www.dd.ru