Hi Richard,
At time=30:00, is it a bad idea to set a HelperT s Short Text field (here, Activity) to Indexed = Yes (No Duplicates)? I tried this on my own database but for some reason, Access  seems to yell at me in corresponding Queries, related to typing in your own values...something about not being able to change the  one  side of the relationship.

---

Reply from Alex Hedley:

Indexes can slow down the db, it keeps another reference to speed up searching, as it's a text field that could contain a lot of information it's generally not the best idea.
Normally you index the fields you're likely to search on often like IDs or Date Fields.