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