Updating multiple indexes in one database?
Posted on 2002-03-05
I am keeping track of tape stock broken down into types - Master Tapes, Stock footage, etc. Right now they are in separate databases so they can have separate indexes and I can number the tapes by their type and index number. I want to be able to have them all in one database so that I can search for tapes using one query, instead of doing the same search in each database, and also add records for any tape type wher the proper index will automatically be incremented.
The index is just the number of tapes (hence the number of records) of any particular type of tape.