Take the 2-minute tour ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

Whats the best way to go about this:

I have a user list that someone enters item information in. Then a user enters an item, we want to have that item automatically created in an identical admin list. Then be able to change some fields in the admin list. These edited fields will then be updated to the user list when changed in the admin list.

share|improve this question
    
Go Rockets btw! –  PirateEric May 23 at 20:42
add comment

1 Answer 1

up vote 1 down vote accepted

I would say using workflow to do it but it could get messy if not planned appropriately.

The destination list will need to have a lookup column to the source list to maintain referential integrity or things could get out of sync. When a user creates an item in the source list, it creates an item in the destination list and sets the lookup column to link them together.

Then in the destination list you would have a workflow that rights to the source list, looking up what item to update via the lookup column.

This would require that users on the source list have access to add items to the destination list, unless you plan to add an impersonation step in the workflow.

share|improve this answer
    
If I have a workflow on both lists that starts when an item is modified, will this cause an infinite loop because the workflows will keep modifying the list? –  Bobcat88 May 27 at 17:40
    
No, the system should not allow that to happen. –  PirateEric May 27 at 17:51
    
Okay well I'll will let you know pretyy soon, ha –  Bobcat88 May 27 at 17:53
    
Hmmm kind of strange actaully, I use nintex workflow instead on sharepoint designer. So I make the change on one list and it will do the change then there are 5 more versions added after that but those are making no change. So it seems as if it does loop but then stops. I do need to make some changes to this somehow though because I want proper versioning –  Bobcat88 May 27 at 18:07
    
5 more versions of what? Not sure what you are trying to do exactly, the workflows are only going to affect the related item, a 1 to 1 update of the source and child. Where is this one to many versioning thing happening? –  PirateEric May 27 at 18:36
show 1 more comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.