Re: Forms: multiline details and multiline masters

From: Mike Dwyer <dwyermj_at_co,larimer.co.us>
Date: 2000/06/27
Message-ID: <kY665.75$Pl2.38736_at_wdc-read-01.qwest.net>#1/1

I was imagining from your original post that you wanted something like this: EMPLOYEES:
EmpNo EmpName DeptNo

1             King          10
2             Kong         10
3             Knight        20
4             Dark          20

DEPARTMENT
DeptNo DeptName
10 Accounting

As you scroll through the employees, their department record appears below.

Employees is the "master" block; Department is the "detail" block.

Your second post sounds like you want this: EMPLOYEES:
EmpNo EmpName DeptNo

1             King          10
2             Kong         10
3             Knight        20
4             Dark          20

DEPARTMENT
DeptNo DeptName

10           Accounting
20           Marketing

And, as you scroll through the employees, there is no change in the Department block.

That would not be a master-detail relationship. It sounds like you want two independent blocks, but that share a common WHERE clause. You can do that with the appropriate triggers, depending on what kind of navigation you have in the two blocks.

"Denis Ricard" <dricard_at_sympatico.ca> wrote in message news:39582E16.8D4A7975_at_sympatico.ca...
> Hello Mike,
> If I do as you have described, is it possible to display all the "masters"
 of
> the 2nd block simultaneously, and not only those related to the current
 record
> in the 1st block? That is what I want. I want the 2nd block to be a
 multi-line
> block, displaying more than 1 record at a time.
> The records in the 2nd block don't have to be coordinated in any way with
 the
> current record in the 1st block.
>
> Thanks again,
>
> Mike Dwyer wrote:
>
> > You should be able to do this if you set up the form with your "details"
 as
> > a master block and your "masters" as a detail block. That is how you
 have
> > described them.
> >
> > "Denis Ricard" <dricard_at_sympatico.ca> wrote in message
> > news:3956B23C.8B74B060_at_sympatico.ca...
> > > Hello all,
> > >
> > > In a form (V5.0), I have a form with 2 blocks.
> > > The 1st block is a multiline detail block, (related to more than 1
> > > master record)
> > > I want to display in the 2nd block, all masters that are related to
> > > details
> > > displayed in the 1st block, but I want each master to be displayed
 only
> > > once.
> > >
> > > Is there a "simple" way to do this?
> > > Thanks in advance,
> > > Lisa T
> > >
>
Received on Tue Jun 27 2000 - 00:00:00 CEST