Linking Tables

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

Article #252

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

#252

From: Bradner/Klein
Date: Fri, 18 Dec 1998 00:00

19 lines
1209 bytes

Even after looking at the news group archives I'm not fully understanding
the index requirements for linking two tables with masterRowset and
masterFields.

In this example ...

form.query2.rowset.masterRowset=form.query1.rowset
form.query2.rowset.masterFields="state"

is it necessary that both parent and child tables be indexed on the field
"state"? I actually want the child table sorted differently, according to a
date field.

Also, I've got a button that clears some filtering criteria and re-states
the query1 SQL as 'select * from tablename.' For some reason that cuts the
masterRowset relation with query2. Why is that? The relationship remains
intact if I re-state the linking code (as shown in the above example).

Thanks for advice.

Technical Details

Message-ID: <75f82q$2jl10@forums.borland.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: ff5a1,1c2859de4a90efed,start
X-Google-Attributes: gidff5a1,public
From: "Bradner/Klein" <zap.p1554@mail.aai.arco.com>
Subject: Linking Tables
Date: 1998/12/18
Message-ID: <75f82q$2jl10@forums.borland.com>
X-Deja-AN: 423832749
Organization: Another Netscape Collabra Server User
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.2106.4
Newsgroups: borland.public.vdbase.data.sql