could someone give me an advice, which method to use?
I have list with several columns:
Product - Company - Type - Group - Adrress ( example)
I build the form with some cascade dropdown's:
Company - set company value.
Type - dropdown
Group - dropdown
Product - in this column I want get values from external list, which filter by values: Company, type, group.
How to do this thing?
1. Create calculated column in list, which combine company+type+group and filtered by it?
2. Use ajax and send values to view and get product titles?
This solution -> Three-Tier Cascading Drop Downs: Do Go Chasing Waterfalls! would work for me, but I have only one list, not 3..
So looking for solution!