Show Parent child values

Question

Hi,

I have a custom list, in which i have 2 columns - FirstName, LastName. (both are single line of text)

I have the data as below:

First Name  LastName

John             Mac

John             Joe

John             Rick

Mark             Miller

Mark             steve

Mark             tom

I have created another custom list, in which i want to show the data from the first list. I created 2 lookup columns for the same and mapped the first name and last name. I want to display the unique values in the firstname and depending on the selection of firstname, the corresponding last name should be displayed in the second column.

How to achieve this?

Thank you

Answer 1

Hi,

You can modify your page and filter the value based on first name selection. I believe you want this on newform.aspx and editform.aspx page. you can edit both pages using designer and create a new data connection to get last name based on first name.

Here is good link to edit page in designer:

http://blog.erikvl87.nl/2010/10/how-to-create-a-cascading-drop-down-list-in-sharepoint-2010/

Hope it helps

---

Cheers, Hemendra-MCTS "Yesterday is just a memory,Tomorrow we may never see"

Answer 2

Hi,

I checked this:

https://www.nothingbutsharepoint.com/sites/eusp/Pages/Browser-Based-InfoPath-2010---Creating-Cascading-Dropdown-Fields-with-no-Code.aspx

This helped.

Thank you