Re: ADO - ClientDataSet - Master/Detail

Davide Pasqualini wrote:

So, my question is: How new detail records can get the master value ?

If I understand you correctly, you have to assign the primary key of
the master to the foreign key of each new detail record.

--
Bill Todd (TeamB)
.

Relevant Pages

  • Re: Search Form - Take 2
    ... While in Design mode, highlight all of the fields you want to include in the ... selected fields to the primary key. ... as its due to the fact that the columns in master allow Nulls. ... well enter the same 'keyword' slightly differently, ...
    (microsoft.public.access.gettingstarted)
  • Re: Search Form - Take 2
    ... selected fields to the primary key. ... description column in Recommendations or Accomplishments you'll have some ... as its due to the fact that the columns in master allow Nulls. ... well enter the same 'keyword' slightly differently, ...
    (microsoft.public.access.gettingstarted)
  • Row cannot be located for updating
    ... I have a master table and a detail table. ... (autoincrement field and primary key in MasterTable) ... with the proper ID value! ... I've just discovered that even the primary key of MasterTable ...
    (borland.public.delphi.database.ado)
  • Re: Row cannot be located for updating
    ... Both primary keys in MasterTable and DetailTable are Autoincrement field ... But the problem seems to be on the Primary key fields, ... > The master linking field in the detail table needs to be of type Integer ...
    (borland.public.delphi.database.ado)
  • Re: Cannot add record for child table that have relationship with master table.
    ... If your tables don't have a relation in the database than you have to add ... Of course have you to create the master record first before you can add any ... detail table have a relationship with th master table with a primary key. ... because of datagrid will automatic add primary key relation to the master ...
    (microsoft.public.dotnet.framework.adonet)