The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.
For something like this, I do think linked records could be a good way to go. I use a system that’s kind of similar, and breaking it into two tables (employees and jobs) has been a lifesaver for me. Each employee gets linked to a specific job title, ...
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.