I need help (other than the menu Help) in OpenOffice.org Base.
I have created a simple database containing only two tables (Job and
Source). One table lists all possible sources of jobs I receive along
with the corresponding commision rates. I want to enter information
into the Job table and have it look up information from the Source
table. I figured out how to make a relation but don't know how to
invoke its use. I still haven't figured out how to create (let alone
use) a query. When coming to the Job.SourceID field, instead of
entering a number, I would like to have a drop-down box showing a list
"Soure.SourceName". Making a selection from that list should show that
selection (not the ID number) and apply the corresponding commission
rate: Source.Rate*(Job.Paid-Job.Parts) and plug that into "Job.My$Comm".
Creating a form will accept fields from only one table or query.
I just figured out how to create a View that allows fields from multiple
tables, but crashed OO when trying to modify the layout. I can move the
mouse, but clicking does no good. (Fortunately I already had this login
running.)
Here's a partial list from "ps aux":
gvl 9981 0.0 0.2 4332 1056 ? S 15:15 0:00 /bin/sh
/usr/lib/openoffice.org2.0/program/soffice -base
gvl 9992 0.0 3.4 71368 15464 ? Sl 15:15 0:00
/usr/lib/openoffice.org2.0/program/soffice.bin -base
gvl 10257 0.0 0.2 4332 1056 ? S 15:32 0:00 /bin/sh
/usr/lib/openoffice.org2.0/program/soffice -base
gvl 10268 0.0 3.4 71372 15464 ? Sl 15:32 0:00
/usr/lib/openoffice.org2.0/program/soffice.bin -base
gvl 10278 0.0 0.2 2976 1180 ? Ss 15:33 0:00
/usr/bin/esd -terminate -nobeeps -as 2 -spawnfd 28
Here's the same section, but from "ps -Helf":
0 S gvl 9981 1 0 78 0 - 1083 wait 15:15 ?
00:00:00 /bin/sh /usr/lib/openoffice.org2.0/program/soffice -base
0 S gvl 9992 9981 0 78 0 - 17842 stext 15:15 ?
00:00:00 /usr/lib/openoffice.org2.0/program/soffice.bin -base
0 S gvl 10257 1 0 76 0 - 1083 wait 15:32 ?
00:00:00 /bin/sh /usr/lib/openoffice.org2.0/program/soffice -base
0 S gvl 10268 10257 0 79 0 - 17843 stext 15:32 ?
00:00:00 /usr/lib/openoffice.org2.0/program/soffice.bin -base
0 S gvl 10278 1 0 77 0 - 744 - 15:33 ?
00:00:00 /usr/bin/esd -terminate -nobeeps -as 2 -spawnfd 28
(I wish there were a way to tell Mozilla to disable line wrapping for a
specified section.)
I just killed 10278 with no apparent change, other than 10278
disappearing. Same thing for 10268 except that 10257 disappeared with
it. Same thing with 9992 (took 9981 with it). Looks like there's more
to it than the section I chose. Here we go:
0 S gvl 8372 1 0 85 0 - 1083 wait 11:02 ?
00:00:00 /bin/sh /usr/lib/openoffice.org2.0/program/soffice -base
0 S gvl 8383 8372 4 75 0 - 83979 stext 11:02 ?
00:11:51 /usr/lib/openoffice.org2.0/program/soffice.bin -base
Killing 8383 doesn't. (Maybe Linux gurus are wincing at my using this
process, but I'm trying.) "kill -9 8383" (on this graphical session)
jumped me back over to the frozen graphical session and killed that
entire graphical login. It bounced me back to the graphical login
screen. Ctl-Alt-F9 brought me back here. (Now how do I switch back to
the graphical login screen I just switched away from? That is something
I really would like to know. When I have access to the RedHat FC4 menu,
I can choose the icon that does it. But what about when I walk up to a
machine where someone else is logged in and their screensaver is active?
Switching over to F1 and entering the command "gdmflexiserver" fails.)
Back to the subject, I've been searching through the Help, and can't
find what I'm looking for. Maybe it's been right under my nose and I
just don't understand it. I'm having a rather steep learning curve.
I used to dabble in foxbase (DOS based). I got to where I could do that
sort of stuff fairly well. But time finds me severely out of practice.
--
[email protected]
http://www.kernel-panic.org/cgi-bin/mailman/listinfo/kplug-lpsg
