Board index » delphi » Problem when inserting records in the detail table (master/detail relation)

Problem when inserting records in the detail table (master/detail relation)

I often have this problem, when using D2 : I use a Master/detail relation,
using the MasterSource and MasterFields properties of the detail table, and
when I use an "append" method in the detail table, the new record isn't
created. The "new" record is the last one of the table. But this problem doen't
happen with every Master/Detail relation, and I'm puzzled, since I can't see
any difference. Is this due to a specific property of one TTable or one DataSet
? If you know this, it could be very helpful

My e-mail is duran...@worldnet.fr

 

Re:Problem when inserting records in the detail table (master/detail relation)


Can you provide a bit more information?  How are the tables linked,
and what code are you using to append records to the detail table?

In article <6eu0rn$hu...@news3.isdnet.net>, gouy (duran...@worldnet.fr)
writes:

Quote
>I often have this problem, when using D2 : I use a Master/detail relation,
>using the MasterSource and MasterFields properties of the detail table, and
>when I use an "append" method in the detail table, the new record isn't
>created. The "new" record is the last one of the table. But this problem doen't
>happen with every Master/Detail relation, and I'm puzzled, since I can't see
>any difference. Is this due to a specific property of one TTable or one DataSet
>? If you know this, it could be very helpful

>My e-mail is duran...@worldnet.fr

Re:Problem when inserting records in the detail table (master/detail relation)


Keep in mind that the detail table is basically "Filtered" table depending
on where the master table is pointing.  If the record that you insert into
the detail table doesn't "meet the criteria" of the current master table
record, you won't see it (until you move to a master record that includes
the detail you just added).

Quote
>In article <6eu0rn$hu...@news3.isdnet.net>, gouy (duran...@worldnet.fr)
>writes:
>>I often have this problem, when using D2 : I use a Master/detail relation,
>>using the MasterSource and MasterFields properties of the detail table,
and
>>when I use an "append" method in the detail table, the new record isn't
>>created. The "new" record is the last one of the table. But this problem
doen't
>>happen with every Master/Detail relation, and I'm puzzled, since I can't
see
>>any difference. Is this due to a specific property of one TTable or one
DataSet
>>? If you know this, it could be very helpful

>>My e-mail is duran...@worldnet.fr

Other Threads