Home General
New Blog Posts: Merging Reports - Part 1 and Part 2

master/detail relationship

edited April 2002 in General
Hi, it's me again. I have got another problem. I have to define a
master/detail relationship dynamically at run time.
I tried the Tech-tip from Nard Moseley from 07.01.2002 , but in the end I
didn't succeed. Is there a different way
to do that?
Thanks in advance
Andreas

Comments

  • edited April 2002
    There are a number of different ways of creating master-detail relationship.
    They include:

    a) Linking at the data source level - Place two table or query objects and
    two data source objects on the form and connect them respectively. Set the
    MasterSource property of the detail table to the data source of the master
    table and set the master fields to create a link.

    b) Linking at the data pipeline level - Attach a data pipeline to each data
    source in the setup from a). Set the MasterDataPipeline of the detail
    pipeline to the master pipeline and set the MasterFieldLinks to create a
    link.

    c) Linking in DADE - Create two dataviews, one for the master qeuery and one
    for the detail query. Drag the field you would like to link on from the
    detail data view to the master data view. That will create a visual link
    between the data views.

    See demos 71-80 in the RBuilder/Demos/Reports directory.

    You can apply the same techniques at design and at runtime.

    --
    Cheers,

    Alexander Kramnik
    Digital Metaphors

This discussion has been closed.