It looks like Moodle isn't going to work for the task at hand.
After a little further investigating it turns out that Drupal 7's module 'Entity Reference' does the job quite well. The module is being built into Drupal 8.
For those not familiar with Drupal it's like WordPress on steriods. There is a steep learning curve, but worth it. It is better suited for larger organizations where it is used most often.