I'm just getting started with Sharepoint 2007 and am on pg 87 of the book - so, I'm leaping ahead a bit with this question.

Suppose I have a Contacts list with names, companies, phone numbers.

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 from my afore-mentioned Contacts list? And then, when a Contact name is selected, my Projects list is automatically populated with the contact info from my Contacts list? Rather Access-like, I suppose.

If this is covered later in the book, that's fine -- I just want to know if it will be possible.

Joe

If you have found the answer to this question, can you post a reply - I am trying to do something similar. Have found you can do lookups to other lists, but can't see how you can populate/or limit a second field based on the lookup in the first field.

Thanks
Kevin

Unfortunately, no. I haven't sorted this out yet.

Can you use SharePoint Designer for this? If yes, I found this http://blah.winsmarts.com/2007-10-Pe...int_lists.aspx . I have not tried it myself.

Hope it help

I want to know that.