⚠ In case you've missed it, we have migrated to our new website, with a brand new forum. For more details about the migration you can read our blog post for website migration. This is an archived forum. ⚠

  •     

profile picture

customize add cours



eamon250d

eamon250d
  • profile picture
  • Member

Posted 22 February 2016 - 07:46 AM

Hi to all ,

I wanted to customize my custom code as follows

I wonder if you have an idea
Thank you

 


SELECT
film.title,
film.courstheorique_date,
fullname ,
film.film_id ,  
film_actor.actor_id
FROM actor, film_actor , film
WHERE actor.actor_id = film_actor.actor_id
AND film_actor.film_id = film.film_id
ORDER BY film.title






1) Step 1
Whene i add new cours :
Insert 'moduleid' into table 'film_actor'


2) Step 2
When i want to add new cours :
After Select for example 'module2'
In the section 'Add all' in the right
Make the display as the result of this query:


SELECT actor.actor_id,actor.fullname FROM actor
WHERE actor.actor_id NOT IN
(SELECT film_actor.actor_id FROM film_actor
WHERE  moduleid <> 2
ORDER BY film_actor.actor_id )



 

 


Amit Shah

Amit Shah
  • profile picture
  • Member

Posted 01 March 2016 - 07:30 AM

Hello my friend, sorry for a delayed response had been very busy / lazy for not to have been attending the forum lately. But a prominent solution for your problem can be found on the following link.

http://grocerycrud.amitsgarage.com/bwl-knowledge-base/conditional-multiselect/

 

Hope you are able to achieve the solution you desire using the same.

 

Happy GCing :)