Rudi,
> One other option, as Nabil suggested, is to have the foreign key the other
> way round. Ie. the parks_address key in the parks_table.
No offense to Nabil, but I can't see a good reason to employ that design.
He's suggesting sort of a "backwards key", which could cause all kinds of
headaches.
--
Josh Berkus
Aglio Database Solutions
San Francisco