In a message dated 2008.06.19 22:00 -0500, Drew Jensen wrote:
Keith Clark wrote:
Is it possible to link two databases through one table? I want to share
a products table between two different databases, as an example.
Short answer is NO - you can not at this time do that.
Drew, sorry to go back more than a year in the archive in my search for
this answer, but...
If it is not possible to link two databases through one table, does that
mean that every application must be organized as a single database?
That seems like an awkward limitation - yet I have not found a way
around it.
[Example application: our church. Databases are at least three:
Persons; Property; Events. Persons must link to Property (as in: who is
responsible for doing what, and how do we get in touch with them?) or
Events (ditto); likewise, Property must link to Events. For example, of
many tables within Persons database, at least two ("Person", "Group")
must link to other databases. Trying to put all of these elements
within a single database seems impossibly unwieldy - so how is the
application practically partitioned?] Setting aside that I expose my
newbiness with such questions, I'm sure that I have overlooked
something, because these must be standard organizational questions. Can
you point me to a reference on how these connections are resolved?
John
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
