I have a school table with a list of schools, a School district table, and a Contacts table.
Schools are linked to school districts.
Contacts can be linked to a school OR a school district.
What I am trying to do is enter a new contact in the contacts table:.
- If the contact is related to a school, I choose the school in the school field and the district field is auto-populated
- If the contact is a district contact (no school) I want to be able to type in or choose the district in the same District field.
I don’t know how to accomplish both in the same district field.