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


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?

Re: Show multiple records [message #188197 is a reply to message #188127] Thu, 17 August 2006 07:21 Go to previous message
Messages: 21148
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)


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: Fri Aug 18 17:06:21 CDT 2017

Total time taken to generate the page: 0.11549 seconds