[Top][All Lists]

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

[GNUe] Inverse Master/Detail relations

From: Andreas Fromm
Subject: [GNUe] Inverse Master/Detail relations
Date: Tue, 16 Aug 2005 13:30:29 +0200
User-agent: Debian Thunderbird 1.0.2 (X11/20050602)

Hash: SHA1


as new GNUe user I first want to thank to all the developers that made
such a nice tool. I tryed out a lot of db-frontends before looking at
gnue, but found out that none of them made it possible to set up an
"application of its own" (from the users point of view) so easy.

I probably will be bothering the list a lot in the next time, as many
questions are arising while building my forms, but I will start with
the most urgent question for me now. How do I set up forms for
multiple tables linked by a master/detail reference, but where the
reference to the detail-record is stored in the master table, as in
the following example:

CREATE TABLE customer (
  id serial PRIMARY KEY,
  name text,
  address integer REFERENCES addresses,

CREATE TABLE addresses(
  adr_id serial PRIMARY KEY,
  street text,

I've allready a form with the master/detail realtion where the
detail-table holds the reference to the master table working pretty
nice. I think this case could be handled with triggers, but I would
like to know if there is a standard way of doing it, before
reinventing the wheel.

Best regards

Andreas Fromm

Version: GnuPG v1.4.1 (GNU/Linux)
Comment: Using GnuPG with Thunderbird -


reply via email to

[Prev in Thread] Current Thread [Next in Thread]