Charting from a value list
I have a database that manages the social account info for our clients and I want to create a dashboard.
I would like to have a value list of our clients then go in and pull up a value list of all of that clients Facebook pages and have the charts show the data for the one selected Facebook page.
I am stuck on how to make this work. I can get it to show data for the client yet it shows up all data for all Facebook pages.
Each client and each Facebook page has its own unique ID.