Hi there Everyone! I just started learning MS Access for a few days. I know a little (very little) VBA Excel programming, but Access is a whole new world for me.
Here is my problem:
I have one table (Database table) with a few columns. There are three rows which are relevant in my problem (the rows are called: "Important_0", "Important_1" and "Important_2"). I have also one form (MainForm) in the file. When I run the query I would like to have a message box pop up where I can input the number I am looking for. Then the query should search for the inputed number in all of the three columns, and display the column names where the number was found in the MainForm form. If found in two columns, then display the names of the two columns, if in three then display the name of all the three columns, if not found than display: "Input number not found". Now I read some articles (and I am reading now Access step by step) and I know that I should normalise my table but I really do not know how to do it. The table attached shows connections. Actually it is a table which was created for showing the connections between codenumbers (for easy example let's say names).
So, as I described, this table shows a three connection chain.
Example:
.............................COLUMNS.......................
Important_0........Important_1.........Important_2.
John -----------> George -----------> Rob
John -----------> George -----------> Michael
John -----------> George -----------> Peter
John -----------> George -----------> Brad
John -----------> Mark -----------> Denis
John -----------> Mark -----------> Jones
John -----------> Smith -----------> Amber
...
...
George -----------> John-----------> LLoyd
George -----------> John -----------> Daniel
Smith -----------> Amber -----------> Clark

In the real file there are more than 140.000 rows which means that there are many many connections, with names present in all three columns (column A, B C). And this is my first problem, how do I normalize this table? Could you give me an advice? How would you do it?

Please check the attached sample table. Thank you in advance for your help!

CROSS-POST: http://www.access-programmers.co.uk/...d.php?t=166037