Master Detail

rbuser

RB 6.3

I need help with making a report from an Address Database with three linked
tables.:

tblName ->tblAddress->tblPhone

Consider the fields:
tblName.Name, tblAddress.Address, tblPhone.PhoneNo

I would like the all of these related fields to print beginning on the same
line - like:

Jones 123 Main St. (555) 123-1234
P,O Box 1234 (555) 234-5678
(555) 345-7890

Smith 345 A St. (666) 666-5432

.
.
.

I have been able to arrange sub reports, or any other method, to accomplish
that format. All help will be appreciated.

Wil

nardmoseley

Try using side by side subreports to prin the tablAddress and tablPhone
data. We have an example of this in the RBuilder\Demos\Reports\Demo.dpr -
the example is slightly different because the master has two details that
are linked to it. But I think the same approach will work.

To implement side by side subpreports, set subreport.ParentWidth to false so
that you can resize the width.


--
Nard Moseley
Digital Metaphors
http://www.digital-metaphors.com

rbuser

Could you direct me to the report in question? I find that there are many
reports in that program.

Thanks.

Wil

rbuser

Sounds like you're using TTables, but if you can switch to TQuery, do a join
on the three tables to get them into one dataset, which will make it very
easy to build a report from.

Also, why are the tables separate in the first place? It sounds like you
should have a single customer table with all that info combined. I am just
spouting off... so ignore this if you like.

Jim

nardmoseley

Demo number 73 (dm0073.pas) in RBuilder\Demos\Reports\Demo.dpr

--
Nard Moseley
Digital Metaphors
http://www.digital-metaphors.com