Hi I have these tables:
- TABLE: Activities with FIELDS: ActivityID (PK), PlaceID
- TABLE:PlacePhotos with FIELDS:PlacePhotoID(PK), PlaceID
I want to build a dashboard with two views:
- A Detail view of an individual record from the Activities table
- A Gallery view sourced from the PlacePhotos table where Activities.PlaceID = PlacePhotos.PlaceID. PlacePhotos can contain ZERO, ONE, or MANY records where PlaceID matches Activities.PlaceID.
I’m launching this Dashboard view when a record is selected in a separate Deck view. Right now I’ve got the Dashboard “working” using a separate “filter” table that is updated with a PlaceID value when the record is selected in the Deck view. Unfortunately this arrangement (at least the way I’ve implemented it) is very slow. I click on the Deck view, the Filter Table eventually gets updated, and the Dashboard view eventually refreshes to show the appropriate data…
There’s gotta be a better or more optimal way to do this. Any suggestions? Thanks!