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.
Scott Axton 7 months ago
The best way to categorize your documents is with something that Richard covered in the Groups video.
If you are not familiar with the concept of using Many-to-Many relationships watch this video first.
I'd just make a "keywords" field and cram whatever words you want to be able to search for in that field. "New hire checklist new employee new guy" for example. Then if you search for "new hire" later you'll get a list of all of the docs that have "new hire" in them.
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.