I have a Power Page Basic form with two lookup columns to the tables (Provider Type and Department) which are related by a third intersect table. It is designed this way because I need the ability to have start and end dates to the many-to-many relationship between Provider Type and Department. When a user selects a Provider Type I want the Department lookup to only display values which are related to the Provider Type as defined in the Provider Type_Department intersect table. The steps I have seen, but I have not made them work yet are:
1. Make both Look Up fields Drop Downs - done
2. Create a Web Template which selects the records I want using FetchXML. - This is probably not written correctly, but I do not know how to test the output
3. Create a Page Template from the Web Template
4. Create a Page from the Page Template
5. Add Custom Java Script to the Form on the page to change the available values for the Department Drop Down.
Is this the best way? If so, how do I write and test the statement in step2.