Click here to Skip to main content
15,902,786 members
Please Sign up or sign in to vote.
1.00/5 (1 vote)
See more:
I hope someone has an answer to this common issue. I have two SP 2010 lists, one parent (Customers, for example) and one child list (Orders, for example). I can easily connect them together in a display form using web parts (selecting a Customer shows related Orders). The problem is when I click Add New Item for the child (Order) web part - it asks the user to manually put the Customer ID for the child, that is, it asks one to put Customer ID manually whenever a new order is being created. It can be done but is very prone to errors and a big pain for users.

This is an extremely common problem in SQL server databases, and Visual Studio and Microsoft Access easily take care of it, out of the box. I don't know why Microsoft has not made it easy to do it in Sharepoint. (I did search Google and there are Javascript-based solutions that haven't worked for me - I am wondering if there is a SharePoint-based solution, preferably without coding, that I can implement). Some coding is fine, if that is the only way to do it.

Much thanks for any help... I really appreciate your time

JD
Posted
Updated 19-Oct-12 5:31am
v2
Comments
Rohit Shrivastava 19-Oct-12 14:26pm    
Is CustomerId in order table is lookup column to Customer table?

1 solution

Yes Rohit CustomerID is a lookup column in Order list. Thanks.
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900