I would like to know if it's possible with SharePoint designer 2010 (foundation) to copy an item from a list to an another list WHERE this another list name = targeted first list column value ?
For example I got 4 lists. List "market", list "fruits", list "vegetables", list "other".
In "market" list I have a column "kind". The values of this column can be : "fruits", "vegetables" or "other". When I approve my item apple (so fruits) I would like to copy this item in the "fruits" list.
The values of this column is in each time equal to the name of the lists.
How can I copy/range my item in terms of this column value ? I have to check all conditions ? I would like to factor precisely...I made this column to avoid this fact.