Re: how to show that there is a detail record


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
.

Relevant Pages

  • Re: Cannot filter detail table.
    ... Joseph I. Ceasar wrote: ... > I connected the DataSet to a DBGrid. ... switch to different Master records and the ... > DBGrid shows the corresponding details for each master. ...
    (borland.public.delphi.database.ado)
  • Re: TAdoData Master Detail Relationships
    ... >create an additional field in the master table to hold the detail records? ... Brian Bushay (TeamB) ...
    (borland.public.delphi.database.ado)
  • Re: Master/Detail with ADODatasets (again)
    ... >I am still having trouble saving detail tables in my ... sync it with the master table. ... Brian Bushay (TeamB) ...
    (borland.public.delphi.database.ado)
  • Re: Problems with Bookmark
    ... Something is very strange here. ... the table and not from the record I click in the DBGrid?? ... Brian Bushay (TeamB) ...
    (borland.public.delphi.database.ado)
  • Re: Help With ,ado and dbgrid1
    ... Brian Bushay TeamB wrote: ... Thing is i am useing a dbgrid1 and need to display all ... info of each access table in the dbgrid at desighn time. ...
    (borland.public.delphi.database.ado)