Logo 
Search:

MOSS Forum

Ask Question   UnAnswered
Home » Forum » MOSS       RSS Feeds

Transferring a column data in one list to another

  Asked By: Jeanne    Date: Jan 24    Category: MOSS    Views: 4222

I have a simple list 1 that has columns NAME VALUE1 VALUE2 TOTAL

I have a simple list 2 that has columns NAME ADRESS TOTAL

I want the Total in LIST 2 to show the TOTAL in LIST 1 automatically
when List 1's total is created by an entry.

A lookup won't work because it is like a dropdown list that you
manually select.

How can I do this in SharePoint MOSS?

Share: 

 

11 Answers Found

 
Answer #1    Answered By: Tamika Cummings     Answered On: Jan 24

Out of the box you can't do what you are trying to do. You're trying to make
sharepoint into a relational database and it just isn't. You could write an
event handler that would either create or update an entry  in list  2 whenever an
entry was added or modified in list 1, but this would require programming.

 
Answer #2    Answered By: Linsey Bauer     Answered On: Jan 24

If these lists are on the same page, could you not create a connection
between these two lists and use Get Parameters From or Get Filter Values
From?

 
Answer #3    Answered By: Ivy Salinas     Answered On: Jan 24

Connections are made between web parts, which are views of lists and not the
lists themselves. Although you could pass parameters or filters between the two
web parts that wouldn't make a change to entries in the underlying lists
themselves, only what the web part displays.

 
Answer #4    Answered By: Kevin Davis     Answered On: Jan 24

Only way to do is to write an ListItem Event Handler..

no other out of box way to keep them in sync.

 
Answer #5    Answered By: Meenakshi Khochar     Answered On: Jan 24

Why not use a workflow that checks for a change on list  1 > total, then
updates list2 > total?

 
Answer #6    Answered By: Latrice Henson     Answered On: Jan 24

Yes, you could also use a workflow that fires when an item is added or changed
in list1, but an event receiver would provide better performance and be easier
to build.

 
Answer #7    Answered By: Nidhi Tiwary     Answered On: Jan 24

Can't he use sharepoint  designer to link the two lists?

Another idea would be workflows which are swell at populating fields
from another list.

Out of the box you can't do what you are trying to do. You're trying to
make sharepoint into a relational database and it just isn't. You could
write an event handler that would either create or update an entry  in
list 2 whenever an entry was added or modified in list  1, but this would
require programming.

 
Answer #8    Answered By: Beatrice Serrano     Answered On: Jan 24

Yes, you could use a workflow but an event receiver would be better performing
and easier to write.

You wouldn't be able to use SharePoint designer. SPD deals with the display of
information, not the underlying lists. You could create a linked data  source
that would allow you to display the Total from list  1 and other fields from List
2 in a Data Form web part, but this wouldn't change the underlying lists.

 
Answer #9    Answered By: Maya Lewis     Answered On: Jan 24

If displaying the total  from list  one along with the 2nd list's other
fields then you wouldn't need to populate another field and SPD is a
nice solution. It would be redundant data  in any event if the 2nd list
got the same info as the first list. Unless he had another reason for
putting that information in that list such as it would get further
calculations etc. down the line.

This does bring me to wonder about performance issues. How heavy are
SPD joins, workflows, and custom code? I am trying to stay away from
custom coded web parts since they might be problematic in the future
when new versions come out as we saw with migration from V2 to V3.
There is a lot you can do with workflows but now you make me stop and
consider, how heavy is the price to use this method? Is it too heavy,
or just heavier?

 
Answer #10    Answered By: Paola Mcmahon     Answered On: Jan 24

Custom coding can be a problem when its time for an upgrade, but not when it
comes to web parts. Upgrading custom site definitions from V2 to V3 was a big
issue, but Web parts were and are backwards compatible. From an upgrade point
of view coding a custom web part is a much safer approach than doing a
customization in SharePoint Designer.

 
Answer #11    Answered By: Justin Mckee     Answered On: Jan 24

I've been reading avidly all your suggestions, and think Paul is on the
right track with event receivers. However, since I am not that far
advanced, I think I'll try to do a workflow that some of you suggested.

The data  from one list  placed into the second list is to do further
calcualtions on it. Specifically, I have created  a list for Employee
reviews that supervisors enter a total  score, and another list that
includes all the salary information for that employee. The total score
is used to do more calculations that will be used to give him/her a big
fat raise

I'll post my findings when I get this going. If you can think of any
more ideas, please feel free to add to this post.

 
Didn't find what you were looking for? Find more on Transferring a column data in one list to another Or get search suggestion and latest updates.




Tagged: