Only show related fields for found set

[wicheese26]

Ive been looking around but havent been able to find much on the topic... Heres the situation;

I have Schedule DB that contains 'show schedule dates' and the name of a 'location' among other things. I also have a Calendar DB that with the relationship of the date, will fill in a portal. This gives shows me all the locations that have shows for that particular date and works great. What I've been trying to see if i can do though is filter the results so it just shows the dates for ONE location that i choose.

I could, for each restaurant, have its own schedule DB, but the problem becomes the opposite when ALL the restaurants need to be shown.

Hope this all makes sense. Any help would be great.

Thanks

-Aron

[falkaholic]

You'll need to use dynamic keys that related based on the date and the location and the same time.

Rather then explain it all, run a search in this forum for "poral filtering" -- that will solve your problem. Lots of info aorund.

[wicheese26]

Hey, thanks a lot! I guess thats what i should have said when i couldnt find anything; I wasnt sure what I was looking for. Sometimes you just need to know the right terms ;-)

-Aron