In my sharepoint list...I have a list that shows the columns. In my first repeating table, I have two drop down list. The two drop down list is retreiving information from Column A and Column B. My second repeating table has a text box only which retrieves information from Column C.
How I want the form to work is, when I select a unique value from column A and column B it should automatically populate value into the text box in the second repeating table. For instance...Column A has values, Basketball, Football, Baseball, etc. When I go to column B, I select values that relates to what I selected in Column A. If it's Basketball, then it give me a unique list to choose from such as point guard, or power forward, etc. Now if I select point guard, then in the second repeating table, it should auto populate the names of the point guards, such as Tom and Bill. Can anyone help on this? Thanks in advance.
Sharepoint Looks like this:
Column A Column B Column C
Basketball Point Guard Tom
Basketball Point Guard Bill
Basketball Power Forward Derek
Basketball Power Forward Matt
Football Quarterback Tim
Football Quarterback Peter
Football Wide Receiver Thomas
Baseball Pitcher Will
Baseball Pitcher Jeff
Baseball Outfielder Steve