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+h...@global.libreoffice.org
In case of problems unsubscribing, write to postmas...@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

Reply via email to