I am not the smartest person at all when it comes to databases. It took me and Google a lot of time to create what I have created, and here's what I need.
I built a database for a local charity motorcycle club for their big yearly anniversary party last year. Mostly went well, a lot of user error that I hope to correct before the next one is August 2012.
Anyways, I had it set up on seven different laptops for the seven different stops. The representative at each stop was supposed to enter a raffle ticket number (which is the primary key) and select the card that they chose out of the deck, save, and next.
Once the run was closed, we called up those who thought they had a winning hand, verified their ticket numbers, then went through each database looking for the cards they had and was then able to verify who had the top 3 hands. What we want to do this upcoming year though is to be able to merge those databases into one master database that'll give us the ticket number of those are the winners and show us their hands in a high hand to lowest hand order. That query is already written into what I have done but I can't figure out how to merge them all to make that happen.
I'd be willing to send a copy of what I've done for anyone who wants to take a look at it. I don't want to post a link for anybody to just download.
Sorry if I'm not fluent enough and I hope you understand what I'm trying to get across and thank you in advance for any help.