Link to home
Start Free TrialLog in
Avatar of sharepointking
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!
Avatar of Sar1973
Sar1973
Flag of Italy image

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?
Avatar of sharepointking
sharepointking

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
ASKER CERTIFIED SOLUTION
Avatar of Sar1973
Sar1973
Flag of Italy image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
can you explain how does this work?
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Is it clear...?