are you storing the IDs separated by commas on a single text column? then you cant create a relationship using MySql.
What you need to do is create another table 'facilities_rooms' , the table will have two columns, 'facility_id' and 'room_id'
Then on the models you can define belongsToMany relationships. See this Laracast for more details https://laracasts.com/series/laravel-5-fundamentals/episodes/21
Sign in to participate in this thread!
The Laravel portal for problem solving, knowledge sharing and community building.
The community