Article View: borland.public.cppbuilder.database.ado
Article #2240Re: Information on setting up relations with in an ADO DB
From: Daniel
Date: Wed, 10 Sep 2003 22:38
Date: Wed, 10 Sep 2003 22:38
26 lines
1994 bytes
1994 bytes
it sounds like you are wanting a master-detail relationship but on a 1-to-1 relationship. Have you tried picking one table (any will do) as the master table then setting all others in master-detail with this database, so that when you change the record of the 'master' table, the records of the detail tables will also change accordingly? if this is not what you are looking for, then please provide more information. "Lee" <gobroski@elltel.net> wrote in message news:3f5ef383$1@newsgroups.borland.com... > Hi every one, > > I am looking for some information on how to set up a relation with in a > non-active Access database created with ado. I want to link one ID field > that has been set up as the Primary field in on each of the 9 tables and > increments on each table as one table is updated. > > any information would be a big help > > Thanks > Lee > >
Technical Details
Message-ID:
<3f5fa7e4@newsgroups.borland.com>Path:
arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-06!sn-xit-05!sn-xit-01!sn-xit-08!supernews.com!hermes.visi.com!priapus.visi.com!news-out.visi.com!petbe.visi.com!news.tele.dk!news.tele.dk!small.news.tele.dk!npeer.de.kpn-eurorings.net!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mailReferences:
<3f5ef383$1@newsgroups.borland.com>Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit X-Google-Thread: 10698b,6df6b657be1b9aae X-Google-Attributes: gid10698b,public X-Google-ArrivalTime: 2003-09-10 15:39:31 PST From: "Daniel" <admin@microsoft.com> Newsgroups: borland.public.cppbuilder.database.ado References: <3f5ef383$1@newsgroups.borland.com> Subject: Re: Information on setting up relations with in an ADO DB Date: Thu, 11 Sep 2003 08:38:28 +1000 Lines: 28 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2800.1106 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106 NNTP-Posting-Host: 202.174.228.150 Message-ID: <3f5fa7e4@newsgroups.borland.com> X-Trace: newsgroups.borland.com 1063233508 202.174.228.150 (10 Sep 2003 15:38:28 -0700) Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-06!sn-xit-05!sn-xit-01!sn-xit-08!supernews.com!hermes.visi.com!priapus.visi.com!news-out.visi.com!petbe.visi.com!news.tele.dk!news.tele.dk!small.news.tele.dk!npeer.de.kpn-eurorings.net!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail