[libreoffice-users] Base: Focus a record based on a sub-form

Consider a simplified table for catalog numbers.

CatalogID: Integer
CountryID: Integer
CatalogNumber: text

Now, consider a simplified Inventory table:

InventoryID: Integer
CatalogID: Integer

The main form contains the inventory information with a sub form 
containing the catalog numbers.

Is there an easy way to tell the form to stop showing the current record 
and go to the record with a specific catalog number?

Sure, I can write a macro attached to a button that asks for the country 
and catalog number (because the catalog number is only unique within a 
country). Unsure how to apply that, however. If there is a decent 
reference, just point me at that.

Trying to decide if I should simply purchase a program, continue with my 
OOo Macro to do this, or if I should just write write an application 
using QT.

--
Andrew Pitonyak
My Macro Document: http://www.pitonyak.org/AndrewMacro.odt
Info:  http://www.pitonyak.org/oo.php


--
Unsubscribe instructions: E-mail to users+help@global.libreoffice.org
In case of problems unsubscribing, write to postmaster@documentfoundation.org
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