Two dynamic pages from one database URL select


So my problem is this. I have developed two dynamic pages from one database and through this it has created two urls. Any subject that has the SACE subject ticked I need to go to the /senior-campus/ pages, any that doesn’t have the tick need to go to the /middle-campus/ pages. Is this possible or do I need to create two separate databases, one for middle campus and one for senior campus?

Thanks in advance for your help!

OK, if I understand you correctly, you are getting IN some kind of URL with some kind of unique identifier to a row in your collection. If so, the easiest would be to do a query with that identifier on the collection, check if that field is checked or not, and then use wix-location to redirect to page A or B. Just make sure to add the full URL-info on the redirect (which is usually the URL you specified when you set up the dynamic page, like …/Mypage{Id} or something.