⚠ 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 forum is read-only and soon will be archived. ⚠

customize add cours

  • Please log in to reply
1 reply to this topic

#1 eamon250d



  • Members
  • PipPip
  • 29 posts

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


fullname ,
film.film_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 )



#2 Amit Shah

Amit Shah

    grocery CRUD Master

  • Advanced Member
  • PipPipPip
  • 1,192 posts

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.



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


Happy GCing :)

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users