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
Mc2102Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

zephyr_hex (Megan)DeveloperCommented:
i think workflow is the way to go.

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.
0
Mc2102Author Commented:
The description above is just an example. The real world list is much longer and more complicated.
0
zephyr_hex (Megan)DeveloperCommented:
if it's more complicated, why not build the tables in SQL, and then use DVWP in sharepoint?

this puts all of the tables & relationships in an actual relational database.  you'd have an employee table, a phone table, etc.  and then create views from those tables to show employees & their phone numbers, for example.

DVWP (data view web part) has the ability to show (and update, delete or insert) data in SQL.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Mc2102Author Commented:
DVWP - I think I will look into that one. Thanks
0
zephyr_hex (Megan)DeveloperCommented:
here's a good starting point:
http://www.lcbridge.nl/vision/2009/dvwp.htm
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SharePoint

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.