Sam Summers
Registered User.
- Local time
- Today, 15:50
- Joined
- Sep 17, 2001
- Messages
- 939
Hi there
I am using 17 tables to hold information on equipment that each use the same fields.
My reason is that for any one piece of equipment there could be as many as 500 - 1000 items so if I were to use one table it may have to hold up to 17000 items.
Is the way I am currently doing it better than having one potentially large table and for Access to have to search for all the items of the required name during searches/queries?
Thank you in advance
Sam
I am using 17 tables to hold information on equipment that each use the same fields.
My reason is that for any one piece of equipment there could be as many as 500 - 1000 items so if I were to use one table it may have to hold up to 17000 items.
Is the way I am currently doing it better than having one potentially large table and for Access to have to search for all the items of the required name during searches/queries?
Thank you in advance
Sam