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

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

Post by gou » Sun, 31 Dec 1899 09:00:00



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


 
 
 

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

Post by Stephen Bro » Sun, 31 Dec 1899 09:00:00


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?


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




 
 
 

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

Post by Russ Rees » Sun, 31 Dec 1899 09:00:00


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).


>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