mrsimmo

ack- yes I see.. Although - the reason I had multiple fields for each broad slot, is that some events might be available to happen at a number of times - Mon PM and Weds AM for instance. I understand that this method would make more sense though. Thanks again, much appreciated... I'm getting there.. I think...

Thanks so much for the replies, folks.  I've taken amended the original post, Matthew. I'm afraid it was a bit late at night when I was writing it - apologies   I've taken your advice comment, and added a new availability table - clearly something I should have done before. So, now - I'm able to see all of the available events on a given day by using a series of filtered portals, using the x operator and each on a different tab. This appears to work *great*! I've attached a new screenshot of my tables, does that make better sense now?  Thanks so much for your help... !    Â

Apologies - I *think* this is a portal question, but it might be that something more fundamental is amiss in my approach... Apologies in advance..  I am working on a scheduling management application for a festival. We collect submissions from artists in a webform in which they also indicate their availability within the 8 days of the festival. Currently this is expressed as a single text field generated by the web form, users are given the option to select am, pm and evening (the broad structure of the festival day) - so the result is a field something like "Mon AM, Tues PM, Sat AM" for each submission.  What I'm trying to create is a schedule form whereby i can see all of the available events on a given day, and then create them as *scheduled* events within our database based on their availability.  Whilst I can filter the submission records as "find where availability = mon", what I want is to be able to see them all on the same screen, so I can enter them as events into our db based on the available pool.  I was thinking that creating a portal would be the way to do this, but can't for the life of me figure out how to view all of the available events on (for example) a monday in it.  I suspect this might be a structural problem rather than a portal misunderstanding, but I'd really appreciate any help... I've attached a screenshot of my current basic schema, where the 'events' table are the public submissions and the 'schedule' table will be the 'actual' festival records.  Apologies - I *think* this is a portal question, but it might be that something more fundamental is amiss in my approach... Apologies in advance..     Many thanks indeed for your help in advance! -i