How to create master-detail table

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

Article #686

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

#686

From: Steven Hui
Date: Wed, 12 Aug 1998 00:00

24 lines
1168 bytes

Hello,
Please advice of some problem below :
1. How to create master - detail table more than 3 table
2. When used SQL join,master rowset& master field, master source
3. Why my linking table always 'Read Only' cann't edit ?, if I tried to join
more than one field
example : I have master table named 'country' & detail table named 'city'
In country database have some field:
country_id
city_id

In city database have some filed :
country_id
city_id
description

My problem is when linking table with field country_id and city_id, the
result query becomes read-only.
If linking with city_id only, that's no problem (I mean data can editable)

thank alot

steven
email :stvhui@indosat.net.id

Technical Details

Message-ID: <6qrhus$3fl11@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,b314e48fb89426df,start
X-Google-Attributes: gidff5a1,public
From: "Steven Hui" <stvhui@indosat.net.id>
Subject: How to create master-detail table
Date: 1998/08/12
Message-ID: <6qrhus$3fl11@forums.borland.com>
X-Deja-AN: 380331655
Organization: Another Netscape Collabra Server User
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3110.3
Newsgroups: borland.public.vdbase.data.sql