populate checklist from column in other tab
Hi,
I'm working on a set of data that I've inherited. Please bear with me as I'm not exactly sure how to ask this - but...
Tab A has a list of colleges (name address, contact info)
Tab B has list of teachers (again more info)
On the teacher tab, I want to specify which colleges they are credentialed to teach at. I'd like this list to be populated from Tab A. I've set up a pop-up menu on other categories, but it won't work for this, as I'd like it to glean info (that will be updating) from Tab A, and also allow multiple choices - Teacher credentialed to teach at multiple colleges.
Conversely, I'd like to be able to click on a college and see what teachers are credentialed.
Can Numbers do this, if so how?
Thanks in advance,
Lembach (is staying)
Mac mini, Mac OS X (10.0.x)