marcq
Member
Hi,
Just wanted to know how it possible to exclude two options (27 and 28) from the database join dropdown list.
I need to keep this two options in the table for editing existing records, but don't need anymore this two options for new records.
I tried in the Data-Where Join Where :
but doesn't work. The 2 options have a display status = 2 and all other options of 1.
I find a solution with JavaScript but it doesn't work with all browser types, so I need a solution.
Any clue how I could do this ?
Thanks a lot in advance for your support. Cheers, marc
Just wanted to know how it possible to exclude two options (27 and 28) from the database join dropdown list.
I need to keep this two options in the table for editing existing records, but don't need anymore this two options for new records.
I tried in the Data-Where Join Where :
Code:
WHERE {thistable}.id IN (SELECT id +3 FROM fab_booking_slots WHERE fab_booking_slots.display = 1) ORDER BY id ASC
but doesn't work. The 2 options have a display status = 2 and all other options of 1.
I find a solution with JavaScript but it doesn't work with all browser types, so I need a solution.
Any clue how I could do this ?
Thanks a lot in advance for your support. Cheers, marc