Title: Filtering Data Project
Last modified: January 24, 2024

---

# Filtering Data Project

 *  Resolved [hporter18](https://wordpress.org/support/users/hporter18/)
 * (@hporter18)
 * [2 years, 4 months ago](https://wordpress.org/support/topic/filtering-data-project/)
 * Hi,
 * I am using WP Data Access to create a web app to manage a Minor Hockey League.
 * I have a division table that stores the different divisions in the league (ie
   u13, u15, u17, etc).  I have one manager responsible for entering information
   for each division (creating teams, rosters, scoresheets, etc) , this association
   is stored in a DivisionManager table with a divisionID and a UserID (ID from 
   wp-users table). The division manager should only be able to see data for their
   division.
 * I am using a WP Data Access Project for the CRUD page for the Teams table.  So
   when the logged in user is a Division Manager for u15 (for example), I want the
   Teams page to load the list of all the teams for the U15 division on page load.
   The divisionID is a foreign Key in the teams table.  Also, when entering a new
   team, I want the division lookup to only populate with U15. I am using a view
   for the form, but need to dynamically pass the divisionID somehow so that the
   correct data is loaded.
 * How can this be accomplished with WP Data Access?

Viewing 1 replies (of 1 total)

 *  Thread Starter [hporter18](https://wordpress.org/support/users/hporter18/)
 * (@hporter18)
 * [2 years, 4 months ago](https://wordpress.org/support/topic/filtering-data-project/#post-17371301)
 * Was able to get it working using URL parameters and wpdadiehard , was using wpdadataproject
   initially. I suspect I’ll get the select lists working using your documentation
   on Dynamic conditional lookups.

Viewing 1 replies (of 1 total)

The topic ‘Filtering Data Project’ is closed to new replies.

 * ![](https://ps.w.org/wp-data-access/assets/icon-256x256.png?rev=3299063)
 * [WP Data Access – App Builder for Tables, Forms, Charts, Maps & Dashboards](https://wordpress.org/plugins/wp-data-access/)
 * [Support Threads](https://wordpress.org/support/plugin/wp-data-access/)
 * [Active Topics](https://wordpress.org/support/plugin/wp-data-access/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/wp-data-access/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/wp-data-access/reviews/)

 * 1 reply
 * 1 participant
 * Last reply from: [hporter18](https://wordpress.org/support/users/hporter18/)
 * Last activity: [2 years, 4 months ago](https://wordpress.org/support/topic/filtering-data-project/#post-17371301)
 * Status: resolved