Home » Developer & Programmer » Forms » Show multiple records
Show multiple records [message #188127] Thu, 17 August 2006 03:56 Go to next message
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.
Re: Show multiple records [message #188197 is a reply to message #188127] Thu, 17 August 2006 07:21 Go to previous message
Littlefoot
Messages: 20901
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.
Previous Topic: Global Variables Or Parameter List ?
Next Topic: Moving Data blocks within Modules?
Goto Forum:
  


Current Time: Sat Dec 10 09:20:46 CST 2016

Total time taken to generate the page: 0.09150 seconds