Hello everybody,
I have the following tables:
People: ID | Name
Activities: ID | Name | Bookable
ActivitiesEnrolments: ID | Activity ID (ref to Activities) | Person ID (ref to People)
ActivitiesBookings: ID | Person ID (ref to People) | Activity ID (ref to Activities)
When I add a new record in ActivitiesBookings, I would like to be able to only select an activity the user is enrolled in, rather than all activities. So, what I really want to see is a list of choices of records in ActivitiesEnrolments filtered by the user ID picked in the "Person ID" select just above.
It's frustrating because I know I've done this before... but it was months ago, and I have no idea how.
LinkedIn
Twitter
