[GNUe] Inverse Master/Detail relations

[Andreas Fromm]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Hi,

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

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.1 (GNU/Linux)
Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org

iD8DBQFDAc5UUmBtSMq5cGURAvMpAKCqjx4O4UOzofpPjS0X91RxVNFw5QCcDwCp
Xp7NprLmLGDWWod5q28nLp8=
=Xx3J
-----END PGP SIGNATURE-----