We have two lists in WSS. One is Projects. It has columns for project name and priority. The second list is Requests. It has request name, project name and priority.
When we create a new request and select a project from a list, we would like the project's priority to be entered into the priority column of the request.
Can this be done?