Access Developer Network

Folders Upload Images Link
Bob Snowball
27 days ago

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
27 days 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.

Richard Rost
26 days ago

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.

Back to Access Developer Network Comments

Subscribe to Access Developer Network
Get notifications when this page is updated