I'm trying to add a new ListItem using the client object model.
List I am adding to has Title, Team (lookup) and Date fields. The list that contains the teams has Team Name, Department and Team Members.
There's nothing stopping each department adding teams with the same name as other departments.
How would I go about adding a new list item with a lookup to the correct team using the COM? I have the department name available to me, so would the best course of action be to run a query on the Teams list filtering on department and start that way, or can I skip that step somehow?
Any advice appreciated!