marcq
Member
Hi,
I need to create a prefilter with another table.
I have a booking table : "fab_booking" (among other the "id" field which is the booking id or number which I need to "link" to the "parent_id" field of the "fab_booking_repeat_book_crewchief" table)
and a table that contains the list of all skippers that has enrolled to for a specific booking (sailing tour booking) : "fab_booking_repeat_book_crewchief" (we can have several skippers for one booking). This table is feed with a databasejoin element.
I would like to retrieve all bookings from the "fab_booking table" where ('{$my->id}') of the logged in user exists in the "fab_booking_repeat_book_crewchief" table.
"id" of the fab_booking should be "linked" to the "parent_id" field of the "fab_booking_repeat_book_crewchief" table in order to get the appropriate bookings.
"id" of the logged in user is saved in the "book_crewchief" field of the "fab_booking_repeat_book_crewchief" table.
Would appreciate your help.
Cheers, marc
I need to create a prefilter with another table.
I have a booking table : "fab_booking" (among other the "id" field which is the booking id or number which I need to "link" to the "parent_id" field of the "fab_booking_repeat_book_crewchief" table)
and a table that contains the list of all skippers that has enrolled to for a specific booking (sailing tour booking) : "fab_booking_repeat_book_crewchief" (we can have several skippers for one booking). This table is feed with a databasejoin element.
I would like to retrieve all bookings from the "fab_booking table" where ('{$my->id}') of the logged in user exists in the "fab_booking_repeat_book_crewchief" table.
"id" of the fab_booking should be "linked" to the "parent_id" field of the "fab_booking_repeat_book_crewchief" table in order to get the appropriate bookings.
"id" of the logged in user is saved in the "book_crewchief" field of the "fab_booking_repeat_book_crewchief" table.
Would appreciate your help.
Cheers, marc