Research Project Design
I have a very complecated schematic for my database with the purpose of studying the way that several things connect together. I have having a few issues. The most pressing issue is how to create a portal in a table of "episodes" (a period of time in which many events occur) that pull events from an events table (one event/table) and matches the events in the portal based on the city field that appears in the events and episodes table. In other words, I want to be able to look at all the events in a given episode for Jacksonville, Florida. I tried using the sort function to accomplish this within the portal but no luck. I need to do a similar thing with actors at a given event. Any advice on how to do these sorts of complex filters would be greatly appreciated.