Referencial Integrady

[Ron Rowell]

I am having a problem with linking a Master/Detail form. I keep getting
a "Key violation error. the tables are lay out like this :

MASTER.TBL
ONEFIELD (KEYED)

DETAIL.TBL
FIELD1 (KEYED)
FIELD2
FIELD3
FIELD4

I tried both of these for field linking (added table descripters so you
can see the order of the link verses Master/Detail:

DETAIL.TBL.FIELD1 -> MASTER.TBL.ONEFIELD
MASTER.TBL.ONEFIELD -> DETAIL.TBL.FIELD1

I used a master/detail form and entering first the master.field data
every thing is fine; then entering detail.field data, the first fields
are auto filled with master.field data creating a "Key Violation" upon
posting?

for testing purposes I tried changing the data in detail.field1 field to
something different to no avail.... I can not under stand this.....

I HAVE read the manuals, and even bought "Database Developers Guide for
Delphi 2" and it to mentions how to make a Master/Detail form but like
the manual, it only touches on it and does NOT touch one common problems
encountered and WHAT to do about them....

Any help would be appreciated....
Thanks

Ron....

[Jay Schwisow]

In article <31FE00...@mail.gatecom.com>, From Ron Rowell
<mrbo...@mail.gatecom.com>, the following was written:

> I used a master/detail form and entering first the master.field data
> every thing is fine; then entering detail.field data, the first
> fields are auto filled with master.field data creating a "Key
> Violation" upon posting?
>
> for testing purposes I tried changing the data in detail.field1 field
> to something different to no avail.... I can not under stand

> this.....> .

Did you post the master record before entering the child information?

God Bless,

--
Jay Schwisow ja...@weldnet.com
07/31/96 20:40
---------
Using: OUI PRO 1.5.0.2 from http://www.dvorak.com

[Ron Rowell]

Thanks for your reply Jay;

If I only enter information in the master part of my form, then post, once I enter the
detail part of the form, the primary keyed field of the detail table has the same data
as the linked master table primary keyed field like my like the field is linked in my
form and not just my table! could this be possable? I used the delphi form expert to
create the Master/Detail form...

one other reply to my question said I needed to use a compound key in my detial table
so I was gona try that soon as I log off, the example tables I used is only a small
database Im using for learning! I have a much larger scale db that I was writing
until I ran into these problems (my first db task) so I cut down the size so I can
learn to crawl before I try walking :-)

Thanks again and If you have any other ideas, please post news or mail....

Ron....