Database relationship

[Lee Mei]

Hello,

Can anybody tell me how to do database ralationship linking between two tables.

Thank you.

[James Lee]

On 28/03/03, 06:18:37, "Lee Mei" wrote regarding Database relationship:

> Can anybody tell me how to do database ralationship linking
> between two tables.

First make sure your database supports relations.

Open the data source, open the database.
From the tables item, select the Relations option.
Add the tables to the graphics area and with the mouse drag the items
to be related together.

If your database does not support relations you might just need to
link items in a query, this can be done in a similar way with the mouse.

[Lars Roesmann]

Hy James,

To establish relations between tables, you need a
Adabas database containing at least two tables. Both tables must have a
primary key.
Open the database in StarOffice Explorer and click "Tables". Right-click
directly above a
table name to open the context menu, and select "Relations".
In the upper left corner of the database view, you will see a button
depicting a small
table icon preceded by a "+". Click this button to open a list of
available tables.
Select a table from the list and click [Add]. Repeat this process, if
necessary, to join
more tables.
For each table, StarOffice displays a field list. Click a database
field, press the left
mouse button and drag to a field in another table. When you release the
mouse button, a
line will be drawn from the field in table 1 to the field in table 2.
This line
represents the relation between the two tables.
When you have established all relations, click "Save" in the function bar.

--
Lars Roesmann
Sun StarNews Support

--
All responses posted to this newsgroup are provided without guarantees
as to the suitability of their use. Although we believe the solutions or
explanations given to be accurate and correct, we cannot guarantee the
accuracy of the information contained.

Please do not reply directly to this e-mail address if you wish to
continue further dicussion of this matter, as you will only receive an
automatic response from our system. Instead, please reply to the message
itself so further assistance can be provided via the newsgroup.
Alternatively, you are welcome to have a look at our website for further
information regarding our support services, which is available at
http://www.sun.com/star/support