Master / Detail Tables

From: Sam G. (ggiunti_at_sympatico.ca)
Date: 09/21/04 

Date: Mon, 20 Sep 2004 22:58:32 -0400

I have a master detail relationship set up between two tables. I am updated
the app to use ADP SQL queries and not BDE tables.

The table automatically lists the detail when the master record moves. I
believe this is not the case with queries so I am thinking that I will have
to handle this by changing the detail query SQL and run it every time the
user moves to a new record in the master. I would use the OnRecordChange
event of the Tdatasource master.

Would this be correct or is there a better way of handling this.

Thanks in advance.

Sam

Relevant Pages

  • question(s) about integrating the document library
    ... I wish to set up my own relational database using SQL server. ... I intend to write a webpart that supplies a summary of the master ... separate folder for each master record, since the user might wish to ...
    (microsoft.public.sharepoint.portalserver)
  • question(s) about integrating the document library
    ... I wish to set up my own relational database using SQL server. ... I intend to write a webpart that supplies a summary of the master ... separate folder for each master record, since the user might wish to ...
    (microsoft.public.sharepoint.windowsservices)
  • Re: How can delete a record in a master-detail relation
    ... paul wrote: ... I can Add, Modify, Save all in the Master and in Detail ... :> CANNOT DELETE THE MASTER RECORD IF THERE ARE CORRESPONDING DETAIL ...
    (comp.databases.oracle.tools)
  • Re: How to avoid update?
    ... as a master and details), it's best to have some kind of batch posting ... so the data is entered into a staging table or with a pending ... or remove the pending status flag on the master record for ... the entry. ...
    (microsoft.public.access.forms)
  • Re: How to avoid update?
    ... as a master and details), it's best to have some kind of batch posting ... so the data is entered into a staging table or with a pending ... or remove the pending status flag on the master record for ... the entry. ...
    (microsoft.public.access.formscoding)