I am working on a wedding website, and would like to build in the ability to RSVP online. Guests are either invited to all events (call them "Guest Type A") or only a few events ("Guest Type B"). I have different Events pages set up for A and B.
I'd like to be able to have everyone enter their last name into a text box/form and, based on their response, direct them to the appropriate Events page.
I first tried setting up a Database with all of the guests' names, then running a data query on that database to get them to the right Events page. However, that doesn't seem to work. Any advice (or a better solution — I am totally new to this) would be incredibly appreciated!