Martin, David wrote:
Hello,
The Ohio Department of Rehabilitation and Correction has graced the Education
Department with Open Office as our means of programming inmates. My question
needs a verbal response, as I have exhausted the Help section and the Open
Office Manual of about 438 pages. Please email me a phone number of someone I
can talk to, to resolve my problem. The problem deals with adding more than one
table to a query.
Thank You,
David Martin
(David, I'm sending this directly to you, since you appear not to be
subscribed to the list, but please keep all discussion on
[email protected] so more people can help. If it gets too complex for
this list, one of the Base-specific lists might work better -- see the
www.openoffice.org website for mailing list info.)
As you've heard from previous responses, this is a volunteer effort, and
the list is widely archived, so it isn't really a good idea to post
personal information.
About your question, let's see if we can help a bit. We'll probably need
more information (including what operating system and version you're on,
and what version of OOo you're using), but it is certainly possible to
have more than one table (or other queries) in a query. You'll need to
set up relationships among them, and perhaps experiment a bit to find
the right order for the tables/queries (they are used from left to
right, and if one is in the wrong place you can drag it around) and what
kind of relationship works best. You apparently have gotten to the point
of selecting one table for the query, so I'll start from there. In
general, the way I've dealt with this type of thing is:
1. Continue adding tables and/or queries until all the ones you want
are shown in the Query Designer, then close the selection dialog.
2. For each relationship, drag a field from one table/query to the
corresponding field in another. The contents need to match for the
relationship to contribute to the results set. A line will appear
between the two fields.
3. Right click on the line connecting the fields and select the
appropriate relationship type.
4. Double-click any fields needed for the query in whichever
table/query applies, and establish any criteria, etc., needed to
get the results.
5. Run the query to see if the results are appropriate, and adjust
criteria, table/query order, and relationship types if necessary.
Note that queries formed in this way can't be used to modify record
contents. This can only be done from a single table query, and only if
one of the included fields in the query is the table's primary key.
Depending on your situation, you may need forms with subforms, and
somebody else will have to help you there -- I haven't dug into it
myself yet.
Hope this helps. If not, it should at least give you an idea of how to
ask your question for best results.
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
