nefda

Thanks Vaughan I had thought of this but was worried about search times in such a large database, although I must admit search times at the moment are pretty fast in an individual database, despite have 10,000 records. However, combining the 5 databases into one would increase the record number to around 40,000. Would this have a really negative effect on search speeds in your expert opinion? Chris

I work for a museum which has 5 separate FMP databases (relationally linked), one for each geographical area the musuem covers. Each db has identical fields and also stores a photo of the artifact in question (detailed in the record). The separate dbs can be searched 'universally' .... one keyword finds every record where that keyword occurs, no matter what field. The search routine (separate screens) that search across all 5 dbs are specific/exact only ... i.e an exact match in one selected field. I need to have the same 'universal' search capability we enjoy on each separate one across all the related databases. I'm sure this question has been asked many times, but (hey) I'm just an intermediate who's lost. Thanks anyone who can provide the answer. Great site, by the way, learnt a huge amount already, just by reading postings! Chris NEFDA