Detail and Autoincremet

klixx

Delphi Developer

Wed, 18 Jun 1902 08:00:00 GMT

Master/Detail and Autoincremet

Maybe a simple problem, but I could nowhere find an answer(just a
beginner) :

I use Delphi 3 with Paradox -Tables.
In my Master-Table I have an autoincrement field as primary key,
and I try to use this field as masterfield for my detail-table, but when

I create new records, the value of the +/- field is not written in my
detail table.
I set the detail-field to integer,numeric... but it doesnt work.
When I use a numeric field as master-field everything is ok, but I need
this autoincrement.

Any suggestions ?

Robert Kapla

Delphi Developer

Wed, 18 Jun 1902 08:00:00 GMT

Re:Master/Detail and Autoincremet

In the OnNewRecord event on the detail, set the appropriate field to the
master key.

Robert

Quote

klixx wrote in message <36472019.1A958...@okay.net>...
>Maybe a simple problem, but I could nowhere find an answer(just a
>beginner) :

>I use Delphi 3 with Paradox -Tables.
>In my Master-Table I have an autoincrement field as primary key,
>and I try to use this field as masterfield for my detail-table, but when

>I create new records, the value of the +/- field is not written in my
>detail table.
>I set the detail-field to integer,numeric... but it doesnt work.
>When I use a numeric field as master-field everything is ok, but I need
>this autoincrement.

>Any suggestions ?

Dave Bisset

Delphi Developer

Wed, 18 Jun 1902 08:00:00 GMT

Re:Master/Detail and Autoincremet

Will this work? I have always posted the master record first (because if it
is new, the autoinc field seems indeterminate), then it picks the value up
properly.

Dave Bissett

Quote

Robert Kaplan wrote in message <727fjk$g1...@news1.iamerica.net>...
>In the OnNewRecord event on the detail, set the appropriate field to the
>master key.

>Robert

>klixx wrote in message <36472019.1A958...@okay.net>...
>>Maybe a simple problem, but I could nowhere find an answer(just a
>>beginner) :

>>I use Delphi 3 with Paradox -Tables.
>>In my Master-Table I have an autoincrement field as primary key,
>>and I try to use this field as masterfield for my detail-table, but when

>>I create new records, the value of the +/- field is not written in my
>>detail table.
>>I set the detail-field to integer,numeric... but it doesnt work.
>>When I use a numeric field as master-field everything is ok, but I need
>>this autoincrement.

>>Any suggestions ?

Other Threads

1. Master-Detail Query w/Cached Updates requeries Detail when updating single fields in Master

2. Master/Detail w/SQL Server shows all detail records when inserting a new master record

3. Problem: Master/Detail shows details during Master Insert

4. Master-detail-detail-detial with Cascade delete

5. Master/Detail lookup - losing detail field

6. HELP: Master-detail form: sequence of detail records

7. Sorting detail records in a master detail relation.

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

9. Different detail Index order within master-detail relationship

10. Master->Detail->Detail Query Too Slow