Re: [libreoffice-users] LibréOffice Base Forms, PostgreSQL (JDBC) and Table Joins

Jim

Is it that you want a single form, comprised of sub forms, whereby 

you can filter assets according to their status i.e. "deployed" or "in stock";
from the results given select a specific asset which presents the result, of that one asset, in a 
sub form from which the asset can be amended?

Alex

On Saturday 22 Feb 2014 13:11:52 Jim Seymour wrote:
> 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

-- 
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