Re: how to show that there is a detail record

Brian Bushay TeamB wrote:
Hi all,

I have a master table and a detail table. I want to show in a dbgrid if the master has a detail-record or not. How can I do this?

Thank you very much


You want to show them in the same Grid? If that is the case create a left Join
query from your tables and use that for your datasource
--
Brian Bushay (TeamB)
Bbushay@xxxxxxxxx
Hi,

Yes, I want to show it in the same grid, but only something like a bool field (tick mark) that there is a detail dataset available or not.

Thank you very much

Detlef Ross
.

Relevant Pages

  • Re: usage of clientdataset with jet
    ... "Brian Bushay TeamB" wrote in message ... > Any database design that has a large number of fields in a table is a poor ... only one record for every record in the master table. ...
    (borland.public.delphi.database.ado)
  • Re: TADOQuery - using 2 detail parameters for same master field
    ... "Brian Bushay TeamB" wrote in message ... > Borlands ADO components are not going to maintain master/Detail with your SQL. ... > the master tables AfterScroll event to handle setting the detail table ...
    (borland.public.delphi.database.ado)
  • Re: Cache Size and AsyncFetch
    ... Brian Bushay TeamB wrote: ... form set with the tables via an ADOConnection. ... Asnyc fetching is incompatible with serverside cursors and also with Delphi data ...
    (borland.public.delphi.database.ado)
  • Re: how to deal with multiple result sets in D6 ADO?
    ... Or do you need to extract data and stuff it into a TStrinGrid ... When you run sp_help in the Query Analyzer, ... Brian Bushay TeamB wrote: ...
    (borland.public.delphi.database.ado)
  • Re: TADOQuery master-details
    ... Brian Bushay TeamB wrote: ... >>My program is to extract athletics results from an access database. ... >>TDataSource - DataSourceAV ...
    (borland.public.delphi.database.ado)