Newbie needs help with Dev 2K form

[Quoted] I am a complete newbie with Developer 2000. I have a program in Delphi 2 which has one screen which I would like to be accessible from the Web, so I am trying to rewrite it as a Dev 2K form. The relevant tables and fields are: (Oracle 7.3)

AGENCY agencyno, agencyname

EMP agencyno, empno, status

VOLUNTEER empno, lname, fname

HOURS agencyno, empno, hours_date, hours

All the agencyno and empno fields are defined as number.

First I would like to have a drop-down list of the agency names.

Then I want a list of the names of people who work for the selected agency -- select lname, fname from volunteer

           where volunteer.empno = emp.empno and
           emp.agencyno = <selected agencyno>

Then I want to show a list of the hours records for the selected empno and agencyno, which the user can update.

I tried to set up a master-detail relationship agency -> emp -> hours, but when I select an agency, I can't execute the query to get the emp record. No explanation, just "unable to execute query".

I would appreciate it if any readers of this newsgroup could help me get started. I have a fairly good understanding of SQL, but I am finding it difficult to get a handle on Dev 2000.

Thanks very much,

Sue Sarlette

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Tue Jan 12 1999 - 21:55:31 CET