Hello Everyone and thanks for your help in advance. I am working on a document storage project for a large medical clinic. Since the project is dealing with patient documents, it has the potential to grow to several thousand records very quickly. There are approximately 10 different category types, each requiring the same table layout. My question is whether to store the meta data for these files into separate tables even though they are identical in layout, or put them in one table. My concerns revolve around the maximum size of a table and also regarding performance once the table gets very large. It would obviously be a great deal easier if I could put everything into one table, but I need to make the solution work. Any help on this issue would be greatly appreciated.