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

  • 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)
  • Re: How do i update a table by another table
    ... always create the original record in the Master ... primary key for each record that will never be duplicated. ... cell tables, be sure to include the primary key from the master table. ... When you need to update the master table, create a query ...
    (microsoft.public.access.gettingstarted)
  • Re: How do I update a cursor after adding a record to the underlying table? Or vice versa?
    ... the second survey. ... generated via their master surveys. ... than that of record id to the primary key field. ... change the buffering to optimistic row. ...
    (microsoft.public.fox.programmer.exchange)