Re: foreign key question

Am Mit, den 09.06.2004 schrieb [email protected] um 9:35:
> You have an org table that holds data from, say, customers and
> providers and one of the fields is the name. Customer record has a field
> that links to the correspondent org record, but you'd like org record
> not to have a field saying if a customer record or a provider one is
> actually linking to it.
> 
> You have a customer form with a master(org) / detail(customer) link so
> the data gets sync and the user just see a whole virtual record. If you
> navigate with the focus at name field, you will obtain org records
> belonging to customers as well as providers.

If I understand you correctly now, the problem could be solved with
making the customer the master and adding the org table as detail?

Thanks,
-- 
Reinhard Mueller
GNU Enterprise project
http://www.gnue.org
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
No army can stop an idea whose time has come.
        -- Victor Hugo, 1802-1885

_______________________________________________
Gnue mailing list
[email protected]
http://lists.gnu.org/mailman/listinfo/gnue

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.4 (GNU/Linux)

iD8DBQBAxsB04LscQraoxVkRArexAJ47ZXYzaES7/VopxN1CbszCVkbtcQCdEBbn
5I743acJUsqAcoByrVKa24o=
=7fT6
-----END PGP SIGNATURE-----