Editing several records at once

[thinbuddha]

I have a library database that keeps track of where items are (and where they have been).

I'm looking for a way to make it easier to send several items to the same person. This would mean altering 5 fields in X number of records by entering the data only once.

I can envision adding a field "ship now" that would be yes/no, and once I decide to ship, the program would automatically alter any records with "yes" in that field, and then change the field to "no" so they don't get shipped in the future. The problem with this is that there are several users using this database, so shipments could easily get confused and routed to the wrong place if I were to do it that way.

Any ideas? Does what I'm asking make any sense?

 

[lebisol]

it would have to be scripted....
-search for fieldX ="yes"
-show only results
-then 'loop' throuhg records and 'SetField value'
perhaps add a field that will hold curret date/time stamp when this script is executed.....any time u have 'time-critical' info i would use some sort of 'audit-trail' concept.
all the best!

:--------------------------------------------------------------------------:

All around in my home town,
They tryin' to track me down...