Questions to be answered for a Filtered View

I have a Table Entries with the following Columns. {Entries}.[Track],[Racing Date],[Race No],[Horse No] [Horse Name][Trainer] [Jockey] …

Column Track is referenced in a table {Tracks}[Track Logo][Track Location]…

To view the entries we are looking that the user selects the track. We did a gallery view with the Tracks. So when user click on Track Logo it opens an inline view of Related Entries (). Here is where the problem starts.
We would like to filter by date.
All Views are available except Form View in the Inline View. So we cannot go further.

If we use the group by Racing Date. We have two problems: 1. the All Group that can send user to the jungle. 2. The Racing Dates are showed like number 45654 with a Warning Symbol.

So it seems that this is not the way.

We would like to go after Racing Date go to Race No and show a filtered data of horses for that Race. Basically, a table view.

  1. Any one has an idea of doing this filtering best way without forms?
  2. This is a common thing in many database apps.? Why this filters aren’t preprogrammed so can be added in Check Boxes?
0 3 170
3 REPLIES 3
Top Labels in this Space