problems linking master/child Access tables in IB

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

1 messages

[T] Back to Threads [V] Tree View [G] Group Articles

1 total messages Started by Byron Kaiser Mon, 23 Mar 1998 00:00

#60

Author: 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

Thread Navigation

This is a paginated view of messages in the thread with full content displayed inline.

Messages are displayed in chronological order, with the original post highlighted in green.

Use pagination controls to navigate through all messages in large threads.

Back to All Threads