I'm looking for a bit more help again... Hopefully I haven't overlooked the answer again and embarrassed myself like last time <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=question&id=3668&image=1&table=forumtopics' class='bbc_emoticon' alt=':o' />
I have a master table called 'events' which holds convention information, including any attending guests and a theme... I also have a table called 'guests' which is a lookup table of various guests as well as a table called 'themes' which is a lookup table of themes...
A event can have multiple guests and multiple themes...
I'm used to MS Access <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=question&id=3668&image=2&table=forumtopics' class='bbc_emoticon' alt=':blink:' /> and would have created a table between the called 'event_guests' and 'event_themes' which would have held the 'event_id' and the id from the other relevant table...
So my question is... When I add a new 'event' how can I attach multiple 'guests' and 'themes' to it? Like maybe a list box where I can hold ctrl and select multiple items?
Thanks in advance
EDIT: I've partially answered my own question (I think)... I created the two tables 'event_guests' and 'event_themes'... The 'event_guests' was set as a master with a detail of 'guests' and same for 'event_themes'... Also the 'events' was set as a master with a detail of 'event_guests' and same for 'event_themes'...
So that has allowed me to attach multiple guests / themes to an event... The result shows up as a link in the list page which when clicked on shows the chosen guests / themes... All good <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=question&id=3668&image=3&table=forumtopics' class='bbc_emoticon' alt=':D' />
However that leaves me with another issue... How can I then do a search for an event that has a particular guest / theme?
Thanks again