Sorry didn't explain it well. Its a Contract DB each table has a unique field. Catalgue Number. An automatic number. One is SAM 001, others are TR001, MH001, CA001. I have 4 different types of Contracts. But I now need to be able to search through all Contracts. Any ideas