2 Databases & Conditional Values -- Can it be done? HELP
I have 2 databases. One is a Faculty, the other is Students.
In the Students DB I want to show their facutly advisor. I want to key in the last name of the advisor and in the next (separate) field I want the Advisor's ID# to pop-up. I've been trying, but I can't do it so I think it may not be possible using 2 databases... is this correct?
Do I have to make a Portal?
I tried putting a portal, but none of the selections seem to be available.