While designing my database I've come across something that, once again, makes my head go all fuzzy and I have to stop and have a bit of a lie down.
I am currently building a library of forms that the company is likely to be using in the future. So far I have around 200. Some of the form are on similar subjects, new hires, company policies, disciplinary letters, appraisals etc. The list is potentially endless.
What's the best way of accessing and choosing the correct form quickly and easily? Is it possible to separate the forms into subject headers? Folders?
I have already built a 'Find a Form' form using the attachment option on the source table, a basic combo box and 'find' button. I fear I will need something a little easier to navigate as the number of forms build.