Value list from several (related) fields?
Student database with several "phone number" fields. I'd like to designate one of them as "primary" for emergency contact.
What I'd LIKE to do is have a separate "PRIMARY PHONE" field, with a pull-down menu consisting of:
- student's cell
- mother's cell
- father's cell
- mother's office
I'm not sure this is even possible; as a fallback, I'll have to put a checkbox near each "phone" field that says, "Designate as primary."
Thanks in advance!