We want to create a database & keyword creation system to sell concert and sports tickets via pay-per-click marketing campaigns . Because new events are being announced on a daily basis that take place all over the U.S. & Canada, there are hundreds of thousands of potential keywords to bid on. We need to automate and simplify the keywords for every new event that we will be promoting. Keywords used in our PPC campaigns are derived from 3 major sources, which we will supply for the project: 1) EVENT NAME (e.g. entertainer, sports team, etc...) 2) VENUE NAME 3) VENUE LOCATION (i.e. city and/or state) 4) Keywords (e.g. ticket, concert ticket, tix, great seats, etc...) What we ultimately need is an easy way to quickly create all of the possible keywords for a given event based on our selecting the actual information (i.e. EVENT NAME, VENUE NAME, VENUE LOCATION) Below is a simple example based on a Madonna tour. An actual tour for a given entertainer would obviously have many more dates/locations/keywords. EVENT NAME: Madonna VENUE NAME: Madison Square Garden, Pepsi Arena VENUE LOCATION: New York City, Albany Keywords: ticket, tickets The finished product would allow us to select the above information from the master database of sports teams, entertainers etc...) and then have the system produce the following output: madonna ticket, madonna tickets, madonna madison square garden, madonna pepsi arena, madonna new york city, madonna albany, madonna ticket new york city, madonna tickets new york city, madonna ticket albany, madonna tickets albany, madonna ticket madison square garden, madonna ticket pepsi arena, madonna tickets madison square garden, madonna tickets pepsi arena, as well as other combinations such as: ticket madonna, tickets madonna, etc... We would supply the list of variables that would ultimately create the output list, e.g. {VENUE NAME}{EVENT NAME}{keyword} {EVENT NAME}{keyword} {EVENT NAME}{VENUE NAME}{keyword} etc.... Ideally, this provides a good outline of what we're looking to create.