OraFAQ Forum: Forms » Show multiple records

Home » Developer & Programmer » Forms » Show multiple records

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Show multiple records [message #188127]

Thu, 17 August 2006 03:56

dr S.A.f.
Messages: 2
Registered: August 2006
Location: Belgium

Junior Member

Hello,

I have the following structure on my form.

A project datablock
A contract datablock (invisible)
And a student datablock (shows 4 records)

One project can have up to 4 contracts, and on each contract there is a student connected, what I want to do is show all students who have a contract with a certain project. But All I get is one student (the one from the first contract found in the db) how can I show them all?

Thx.

Report message to a moderator

Re: Show multiple records [message #188197 is a reply to message #188127]

Thu, 17 August 2006 07:21

Littlefoot
Messages: 21818
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

It seems that you'll have to decide between

MASTER (project) -> DETAIL = MASTER(contract) -> DETAIL (student)

and

MASTER (project) -> DETAIL (contract) 
                 -> DETAIL (student)

First option is your current one: in such a design, it is impossible to show ALL students in the "student" block, because they depend on their master block (contract).

What to do? Well, you could add another tab to the form which would show all students, regardless of current contract. Perhaps it wouldn't be a very good idea to lose existing master-detail relationship.

Report message to a moderator

Previous Topic:	Global Variables Or Parameter List ?
Next Topic:	Moving Data blocks within Modules?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 10:29:36 CDT 2024