Campus field should be table

We often segment our data by using the campus field in the Education Relationship record. However, this is not currently a table which makes it very difficult to query allows too much room for human error (typos, variant spellings/formats etc).

  • Guest
  • Jan 22 2013
  • Attach files
  • Dana Jalovick commented
    May 24, 2019 16:38

    Ditto to Lance's comment!

    Attachments Open full size
  • Guest commented
    March 18, 2016 00:23

    I wholeheartedly agree...currently this is setup where you can base the field on a lookup table (for data consistency), but this would work much smoother if the field could appear as a drop-down in data entry, queries, and exports.

    Attachments Open full size
  • Guest commented
    March 18, 2016 00:23

    It seems like an easy "fix" to make campus a table. Right now you can't even globally change a campus name. What happens when a college renames a campus after a benefactor? Are we supposed to change the campus names oneecord at a time?

    Attachments Open full size

Related ideas