Multiple relationship

[Rafita]

This is my scenario:

Table 1: Services (contains the list of services the company gives)

Table 2: Bookings (contains the reservations made for those services)

-Service

-Date

-Time

I need a relationship that shows all reservations for a Service in a given day in a given time, but if I don’t type anything in time field, I need that the same portal shows all the reservations for that Service in that date.

I’ve been going over again and again: When I leave the time field blank, the portal doesn’t show anything.

Any help would be highly appreciated.

[mr_vodka]

For examples of a filtered portal, see this thread.

http://fmforums.com/forum/showtopic.php?tid/202655

[Rafita]

Thank you very much, Mr. Vodka. Problem solved.