Hi everyone
I am a complete access noobie so please forgive me and I would like to learn access more. I have a database that I created called clarity1 with 2 tables claritydata and copy. I have two tables -the import failed and I had create another table named copy. My aim is to update my pick3 result numbers in the database. I need your help only to get the setup correct....I am totally a noobie. My aim is have 3 columns with numbers linked to a draw or date. So if I click on draw it must list all the numbers from Numbers Numbers2 Numbers3 for this specific date/draw....So those 3 columns must be linked to the draw and date. Every day there is 80 numbers so it must be linked for draw and date. I hope someone that have something similiar setup can help me out. If you would be so kind to help a noobie out it will be highly appreciated.I have attached the database ...hope I have explained it correctly. I would also if possible have a query to check if the winning number is in my +70 odd numbers....thats the aim to save the data in access for a lookup. The winning numbers is updated in Claritydata table. Thank you for any assistance and rep given for your help