On 21-Mar-05, at 1:02 PM, Jerry wrote:
> I've got a DB with entries for a number of different batteries. The
> number entries for each battery will continue to grow over time. Can I
> setup a view for each battery that will show only the records for one
> battery and, if so, how? If not is there another way to do this? I
> initially started this with a separate DB for each battery but would
> really would rather have a single DB and just view them in groups.
-Well the simplest way is to create a filter in the drop down filter
list at the bottom. But if you really want it to be associated with a
view, then here's the process.
-Create the filter in the filter list (as above). Remember also that
filters can use a script notation:
Example: (gt (int %34)0). Where %34 is a date field, and that date
is greater than 0. This taken from a PDA database where the date field
was a Release date, so that unreleased PDA's could be filtered out.
-Create a global script from the options menu
This can perform sorts and invoke a specific named filter (the one
you created above). It would look like:
(sort 1 1)(filt FiltName)
Essentially- Sort by column one, ascending (0 would be
descending), and select the filter named "FiltName".
Test it by selecting the Global script in the list and pressing
the "Execute" button.
-Lastly, create a View, in the Script selector when editing the View,
select the Global script you just made.
By choosing this view, you now not only select the fields you wish to
display and their column widths, but you can sort and filter the
records.
If there's anything else you can do with a "Global" script, besides
sorting and calling filters, I don't think I've seen it mentioned here.
Anyway, I use the above extensively and it's quite useful. One example
of it's usage is a media database where you configure it for CD's,
DVD's, VHS, or books (all using different field types as appropriate -
aspect ratio, sound encoding, publisher, genre, First edition, on-loan,
status, etc) just by selecting a view. In another database I keep
track of target ammunition. One View displays data from Scope sighting
correction values, another view displays data to select the best Long
range round to use comparing FPS, energy at impact, grouping, drop,
etc, another View for medium range target round selection, another View
for inventory - showing full and partial boxes - calculating total
number of rounds - price per round of each type - and totals in number
of rounds and dollars, etc etc.
|
