Click here to Skip to main content
12,067,916 members (31,045 online)
Rate this:
 
Please Sign up or sign in to vote.
See more: SharePoint form
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 19-Oct-12 6:25am
Edited 19-Oct-12 6:31am
v2
Comments
Rohit Shrivastava 19-Oct-12 14:26pm
   
Is CustomerId in order table is lookup column to Customer table?

1 solution

Rate this: bad
 
good
Please Sign up or sign in to vote.

Solution 1

Yes Rohit CustomerID is a lookup column in Order list. Thanks.
  Permalink  

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

  Print Answers RSS
Top Experts
Last 24hrsThis month


Advertise | Privacy | Mobile
Web01 | 2.8.160208.1 | Last Updated 19 Oct 2012
Copyright © CodeProject, 1999-2016
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100