Unanswered: Combing two fields in same table into combo box in another table/query
OK, I am new to databases, and a friend and I are whipping up a database that will run our NCAA basketball pool online (so we need to get moving). Anyway, we have it set up as tables for each round with all the teams, a registration/login info table, and we want separate tables for each participants picks. So in the round 1 table is has user id then their selections for each game in that round. So for the next round, we want to have half as many fields with each having a combo box that will place 2 games from the previous round into one field. We have tried different queries, especially union queries which got us close, but it still is not right. Are there any suggestions out there to do this, or maybe setup differently. Thanks, please help.