Lookup field with filter needed
Hello,
I am having some trouble with SharePoint 2010 Enterprise lists. I have two lists.
Table Name: EMPLOYEES
Column: User - (People or Group)
Column: Phone - (Lookup) --> to table PHONES:Asset No
Table: PHONES
Column: Asset No (Single Line)
As you can see pretty simple. Employees gets phones assigned in the EMPLOYEES list by using the 'Phone' column which is a lookup field pointing to the PHONES list. What I would like to make happen now is that if a phone gets assigned to a employee that it refelcts that in the PHONES list as well. So I would like to add a Single Line column called 'Assigned To' and fill it will the name of the listed in the 'User' column of the EMPLOYEES list. The PHONES: Assigned To column can be read only.
I can do this with a workflow but I need this entry to reflect the fact if the phone gets assigned to another employee or the employee does not get a phone assigned as well. I tried to 12 hours yesterday to get that to work with a WF and I failed.
How can I get this to work? Any ideas?
P.S. I am not a SharePoint developer. I know SharePoint a bit and SharePoint Designer a little so please do not just throw some code at me. Please also tell me how I can implement it or send me a link to a article that explains it.
Thanks in advance for any help.
Mc2102
I am having some trouble with SharePoint 2010 Enterprise lists. I have two lists.
Table Name: EMPLOYEES
Column: User - (People or Group)
Column: Phone - (Lookup) --> to table PHONES:Asset No
Table: PHONES
Column: Asset No (Single Line)
As you can see pretty simple. Employees gets phones assigned in the EMPLOYEES list by using the 'Phone' column which is a lookup field pointing to the PHONES list. What I would like to make happen now is that if a phone gets assigned to a employee that it refelcts that in the PHONES list as well. So I would like to add a Single Line column called 'Assigned To' and fill it will the name of the listed in the 'User' column of the EMPLOYEES list. The PHONES: Assigned To column can be read only.
I can do this with a workflow but I need this entry to reflect the fact if the phone gets assigned to another employee or the employee does not get a phone assigned as well. I tried to 12 hours yesterday to get that to work with a WF and I failed.
How can I get this to work? Any ideas?
P.S. I am not a SharePoint developer. I know SharePoint a bit and SharePoint Designer a little so please do not just throw some code at me. Please also tell me how I can implement it or send me a link to a article that explains it.
Thanks in advance for any help.
Mc2102
ASKER
The description above is just an example. The real world list is much longer and more complicated.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
DVWP - I think I will look into that one. Thanks
here's a good starting point:
http://www.lcbridge.nl/vision/2009/dvwp.htm
http://www.lcbridge.nl/vision/2009/dvwp.htm
you will have conditions in the workflow that trigger it to take the actions you want.
so maybe you should post your best attempt at the workflow, and Experts can help you with the conditions or syntax.