Hi Drew,
In a message dated 2009.10.08 17:47 -0500, Drew Jensen 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.
... 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. ...
Ah - this really shouldn't be a 2 minute answer and I don't mind taking
the time to answer it, but that time is kind of limited this evening - I
will make the time over the next day or two.
Short answer for the moment:
Your database can include multiple tables, each table represents one
entity. (person, property, event)
The data in the tables can be related to each other.
Please don't go to any more trouble; I'd feel guilty about taking your
time (again) - and anyway, I'm not quite /that/ newby. ;-) I was just
looking for a way to connect multiple databases (not multiple tables).
To take my current problem, there are indeed multiple tables within each
database. For example, the Persons db includes, among others, tables
"Persons" and "Families" ["family" loosely defined as persons who live
in the same place]. The Property db includes, among others, tables
"Problems" and "Projects" - each of which wants to link to the "Persons"
table in the Persons db. Similarly with the Events db.
Some databases (Relation Database Management Systms [RDBMS] such as
MySQL, PostgreSQl, SQL Server, Oracle) can refer to tables held within
other databases, others do not.
And, among those that do not, HSQL? Still, you have given examples of
back-ends that can do what I need, if I can port the databases to, say,
MySQL - which probably means I should focus on what is involved in
porting. In that regard, for example, the recent thread "Connection to
MySQL data base" was timely and helpful.
Thanks also for your summary of the contents of a Base file, which was a
helpful complement to my recent experience rebuilding a corrupted Base file.
At this point, I think I should see about how to use Base with MySQL,
since that seems to hold the answer to my concern. I appreciate the
pointers, as always,
John
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
