problems linking master/child Access tables in IB

Article View: borland.public.intrabuilder.data.sql

Article #60

Back to borland.public.intrabuilder.data.sql Previous Next

#60

From: Byron Kaiser
Date: Mon, 23 Mar 1998 00:00

26 lines
1508 bytes

I wish to create a form for online usage that will connect to an
existing
Microsoft Access 97 database.  I have used the BDE's built-in Access
recognition
capability to read in the tables from the DB into IntraBuilder.  What I
am
essentially trying to do is link one set of records from a primary table
to 3
subordinated tables of information in a "one-to-many" relationship.  I
have tried to
use the masterRecord, masterField attributes of each sub-table so that
they will
link up to the primary key of my main record source.  When I establish
the relationship, though, the program automatically enters the text
"PrimaryKey" into the indexField property, and it does not allow me to
overwrite this info. with the correct data, which is
namely the primary key from my main table.  This problem is effectively
disabling me from
making any progress on setting up this online db access tool.

I would appreciate any help.

sincerely,
Byron Kaiser
Chapel Hill Group

Technical Details

Message-ID: <3516E115.C8B624BC@chgrp.com>

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: 101d9a,56046bbe541c7189,start
X-Google-Attributes: gid101d9a,public
From: Byron Kaiser <bkaiser@chgrp.com>
Subject: problems linking master/child Access tables in IB
Date: 1998/03/23
Message-ID: <3516E115.C8B624BC@chgrp.com>
X-Deja-AN: 336967281
Content-Transfer-Encoding: 7bit
X-Priority: 3 (Normal)
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Organization: The Chapel Hill Group
Newsgroups: borland.public.intrabuilder.data.sql