how to send primary key to another table as forgion key

Article View: borland.public.delphi.database

Article #2014

Back to borland.public.delphi.database Previous Next

#2014

From: locutus
Date: Thu, 18 Mar 1999 00:00

13 lines
1333 bytes

I'm new to delphi and database programming and have a lame question to ask.
I have two tables, one with parent information which has a unique parent id
number. The other is of children information, when I register the parent the
data in the dbedit boxes is sent to the parenttable and what I want is for
the  child table to store the parent id as well. In effect I want to copy
ParentTableParentId to ChildTableParentId.
I have tried a few things but keep getting type mismatch errors !
Please help me if you can.

Parentid                        childID
parent name                 child name
parent address             child DOB
parent tel no                  parent id

Technical Details

Message-ID: <7crmm5$rtr$1@news6.svr.pol.co.uk>

Path: arc1-ca.pugleaf.net!unknown!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 115d96,bb734f6335a4936e,start
X-Google-Attributes: gid115d96,public
From: "locutus" <locutus@mclapperton.freeserve.co.uk>
Subject: how to send primary key  to another table as forgion key
Date: 1999/03/18
Message-ID: <7crmm5$rtr$1@news6.svr.pol.co.uk>
X-Deja-AN: 456223851
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3110.3
X-Complaints-To: abuse@theplanet.net
X-Trace: news6.svr.pol.co.uk 921787909 28603 62.136.53.22 (18 Mar 1999 20:11:49 GMT)
Organization: Customer of Planet Online
NNTP-Posting-Date: 18 Mar 1999 20:11:49 GMT
Newsgroups: borland.public.delphi.database