Problem with master detail tables

Hi all,

I use D7, Acces 2003, Jet Engine, BetterADoTables.
I have a database with a chain of master/detail tables and set in Access
referential integrity for updateting und deleting.
I could create a master by
master.append;
master..... assign something
master.post;

A detail record by
detail.append;
detail..... assign something
detail.post;

I changed something (I cannot say what and when) and suddenly I got an error
message at the line <<detail.post>> like "could append record because it
must linked to a master record.

I can repair it by adding a line like
detail[linfield]:=master[linkfield];

But I don't finally understand what hapened. Any idea?

Than you very much

Detlef


.

Relevant Pages

  • Re: ANN: Special kbmMW timelimited offer!
    ... On each master change, get a new matching detail record from the database. ... > What about Master-Detail support? ...
    (borland.public.delphi.thirdpartytools.general)
  • Re: OTHER BIG BUG : deleting detail master delete
    ... database and i want to delete 'simple' a detail record in a table, ADO ... In a master detail relation with transaction and batchoptimistic ...
    (borland.public.delphi.database.ado)
  • Re: Updating Picture on Main Form from Sub Form
    ... a master table and a detail table with multiple detail ... The detail record includes an ole field that is used to contain pictures. ... included the picture in a bound object frame and works. ... unlike VB, it has image, unbound object frame and bound object frame. ...
    (microsoft.public.access.formscoding)
  • Re: Master/Detail + cachedUpdates
    ... > When inserting a new detail record, the linking data is not automatically ... Please be aware that cachedupdates is problematic with linked Master Detail ... dataset situations. ... circumvent this is to apply both master and detail updates in the master ...
    (comp.lang.pascal.delphi.misc)
  • Need example of sophisticated master/detail GUI
    ... good visual context as they drill down from the master to a detail ... and then to a detail record of the detail record.... ...
    (comp.lang.java.gui)