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
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.