Date: prev next · Thread: first prev next last
2014 Archives by date, by thread · List index


Hi There,

I've researched and experimented with this, and I'm out of ideas.

For starters: LibréOffice 3.5.7.2, Build ID: 350m1 (Build: 2)

Before anybody suggests a newer version: I'm currently on Ubuntu
10.04 LTS (Lucid Lynx), so I'm stuck with it.  (Even my much newer
Linux Mint desktop install at work is still 3.x, I believe.)

I have a database with a couple tables, as in

create table hdwr_assets (
  atag           text primary key,
  serno          text unique,
  status_id      int references hdwr_status,
  . 
  .
  .
);

-- e.g.: "deployed", "in stock"
create table hdwr_status (
  status_id serial  primary key,
  descr     text    not null,
);

The plan was to create a form that could query and alter hardware
assets, selecting values for status_id from a drop-down list, the
available selection being from the hardware status table.

Near as I can tell: The Forms Wizard simply isn't that smart?

Interestingly: A Query created in Design View DTRT, wrt FK
references, but I can't persuade the Forms Wizard to do so.  In fact:
FK references in the Forms Wizard appear to be thoroughly broken--at
least in the version of LO I have?

Is there any way to accomplish what I want, or am I going to have to
resort to Real Coding (Java, HTML+PHP+JS or whatever)?

Thanks,
Jim
-- 
Note: My mail server employs *very* aggressive anti-spam
filtering.  If you reply to this email and your email is
rejected, please accept my apologies and let me know via my
web form at <http://jimsun.LinxNet.com/contact/scform.php>.

-- 
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Context


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.