I'm just getting started with Sharepoint 2007 and am reading Amanda Murphy's/Shane Perran's book on it. My appetite is whetted and am now jumping ahead with this question...
Suppose I have a Contacts list with names, companies, phone numbers, etc.
Then, suppose I have another list of, say, projects.
In my Projects list, would it be possible to include, for example, a "references" or some such named field, where names are drawn (selectable) from my afore-mentioned Contacts list? And then, when a Contact name is selected, my Projects list is automatically populated with the (desired) contact info from my Contacts list? Rather Access-like, I suppose.
Joe