Re: foreign key question

Am Mon, den 07.06.2004 schrieb [email protected] um 21:27:
> I have an issue where a form record needs to hold the key of an employee
> belonging to a known org, but, as said before, employee records are linked
> to dept records, that are linked to org records. That is, there isn't an
> employee field that directly links to an org record. Is there a way for
> doing that kind of thing without re-structuring data?

Using appserver, you could access the org of an employee as a field
named "dept.org". You could filter by that, sort by that, or display it.
You could even display a field named "dept.org.name", if the org_org
table has a field "name".

However, I'm not sure if you are using appserver with this application.

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)

iD8DBQBAxMzD4LscQraoxVkRAjV7AJ9OFWnRuErH/IUf7FQOlqRpwPyDTACdG771
oZq+FsggJDMBwmKU1JxkX6Y=
=zlLX
-----END PGP SIGNATURE-----