Re: [libreoffice-users] libreoffice base: building query, need help with input parameter development

On form Form_Filter, is it possible to define the List Box using General -
List Entries and Data - ValuelList (without using the separate table Filter
and query Query_Filter)?  The Base Handbook has brief comments on the List
Entries & ValueList but only defining those items does not produce a
working List Box.

On Sun, Aug 28, 2016 at 3:23 AM, Robert Großkopf <robert@familiegrosskopf.de
> wrote:

> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
> Hi Alanon,
>
> could be you are looking for something like this:
>
> http://robert.familiegrosskopf.de/download/Filter_Database.odb
>
> One table "Table" with the content you will list, one other table
> called "Filter" with only one row. A query lists the content of
> "Table" dependent of the content of "Filter".
>
> In the form there are two separate forms - one for "Filter", one for
> the query. "Filter" will read out the value you have choosen from a
> listbox. The button refreshes the other form for the query. There are
> no macros needed.
>
> Regards
>
> Robert
> -----BEGIN PGP SIGNATURE-----
> Version: GnuPG v2
>
> iQIcBAEBAgAGBQJXwpGJAAoJELDKYwaoS9AIIKcP/RpIgCBKZ6jtbSx8EudE9A4i
> SslUhyoPzIgAOSn3daOdOLq/jBTVEOo9hF24lwiu31tyuOU2/vTYvYsXe/0hpfUp
> ieJcr+jVMuVTEPIr7OtskgCkASlMDBnxe3vvzoorYSEr47xW+eczcfxINRH1r9FF
> PtKhI6RRcVYDzj3meUjBPHnVrE9Wh8/7RX9+GJPVcU/GtQE3Yps77FsOhwE/iQah
> q4q2wCjzYWgVTV7ls7YX1Em+dsXLuHsJtyqDaGnJr5U0hb10bLSL0D2ge8ujvMiQ
> ypizv/gaKD9D7SUkfHkrqyMkmx5PPbTX+BVX0P1AjHNCAj1P99T3Nt0bRYFbffVq
> 0x1a1Bt+68BZWI6sfKM6mr8fy3ZYSCdQ0uJhKklTke4ETR+2zXnLsNXUzWYJavrh
> bqED7tlXvh6e0KGRARBLHXxbwN2JJx2LuODs3n0wZtqsSJu5aWdNCPnvPV7QGaRQ
> dl585Kx3k73mn5iyWSnC8NSPsz7qZ6ypA8QJdPi6wy6pdfQ1tTopawqX0d+RTFBk
> DGN+Fo+zVifGGPYDcNWw0SxszGNi1JiuJL4ef2GwAmF6ctmFVhR6znE6UPF92uSY
> K81zrlgmqNRfVlpW1TpVPvE8gnCqakmNNVZGEZwI+S5umfMiOGjynmoWZDGgYHUk
> xxmRPkrgAPQTN/pr26w2
> =MDTk
> -----END PGP SIGNATURE-----
>
> --
> 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

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