sharepointking
asked on
Dropdown list - connections
Hi experts!
I have 2 lists (A and B) and they all have a common column called ProductID.
Firstly, how do I create a dropdown of list A, with the values as Product ID column
For example, when a specific ProductID is selected through the dropdown of A, all the products from list B will be shown automatically. When another product ID is selected, the relevant products are shown
If it is javascript, please provide the code.
I'm on SP2007.
Thanks!
I have 2 lists (A and B) and they all have a common column called ProductID.
Firstly, how do I create a dropdown of list A, with the values as Product ID column
For example, when a specific ProductID is selected through the dropdown of A, all the products from list B will be shown automatically. When another product ID is selected, the relevant products are shown
If it is javascript, please provide the code.
I'm on SP2007.
Thanks!
Could you post a table with an example of the data you mentioned? Also, where does this data comes from if not directly declared in a JS array or in HTML?
ASKER
SharePoint List A:
ProductID
100
101
102
103
SharePoint List B:
ProductID Products
100 toy
100 pencils
101 vouchers
101 coins
102 hotel stay
so when the dropdown is selected in 'A' is 100
toy
pencils
will be shown in List B
ProductID
100
101
102
103
SharePoint List B:
ProductID Products
100 toy
100 pencils
101 vouchers
101 coins
102 hotel stay
so when the dropdown is selected in 'A' is 100
toy
pencils
will be shown in List B
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
can you explain how does this work?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Is it clear...?