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: [email protected] 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
