Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

Finally got things to work! Here's a working example of what I have been trying to get to work for weeks of my spare time:

Lookup2.odb

As noted in the code the solution uses a loop rather than a fast, indexed lookup function. Perhaps someday LO can add a findFirst type of function to support this using indexes.

Finally got things to work! Here's a working example of what I have been trying to get to work for weeks of my spare time:

Lookup2.odb (Edit: fixed tabbing. Thanks Ratslinger.)

As noted in the code the solution uses a loop rather than a fast, indexed lookup function. Perhaps someday LO can add a findFirst type of function to support this using indexes.

Finally got things to work! Here's a working example of what I have been trying to get to work for weeks of my spare time:

Lookup2.odb (Edit: fixed tabbing. Thanks Ratslinger.)

image description

As noted in the code the solution uses a loop rather than a fast, indexed lookup function. Perhaps someday LO can add a findFirst type of function to support this using indexes.

Finally got things to work! Here's a working example of what I have been trying to get to work for weeks of my spare time:

Lookup2.odb (Edit: fixed tabbing. Thanks Ratslinger.)

image description

And this leaves filtering available for other uses.

As noted in the code the solution uses a loop rather than a fast, indexed lookup function. Perhaps someday LO can add a findFirst type of function to support this using indexes.

Here's the updated form design I promised.

  • It now allows simple or complex (e.g. Last, First name) sorted lookups.
  • It now works with both HSLQDB 1.8 and MySQL (currently it's configured for HSQLDB 1.8).
  • It's Basic code is much easer to setup and install than before.
  • It fixes an issue with the combo box selectors to make for a better user experience.

image description

I'll keep the original, simpler version below for reference.


Finally got things to work! Here's a working example of what I have been trying to get to work for weeks of my spare time:

Lookup2.odb (Edit: fixed tabbing. Thanks Ratslinger.)

image description

And this leaves filtering available for other uses.

As noted in the code the solution uses a loop rather than a fast, indexed lookup function. Perhaps someday LO can add a findFirst type of function to support this using indexes.