my first question on SE... most of the time my question has already been asked so I never felt a need to signup in the past. But here we are. It is a bit of a complicated scenario and so I am having trouble even understanding where to begin.
I have an accessdb that I am building; this db is primarily a table of results from specific tests we do on products. There are variable results possible for each test type. Therefore, each result is keyed. The results can be grouped by the product conceptually. The results themselves are linked to another table which lists project details that necessitated the tests. Each project is keyed also.
Occasionally (and randomly) we perform all the tests we performed on a product twice for quality purposes which means there are two different keys that can be related by result. We evaluate the results to test the quality.
I am trying to figure out a way to pull the two results in the one table (i.e., keyed pairs) into a new table which can then be evaluated using a calculation.
Some of my ideas include:
Creating a self-join in the table that allows the two pairs to be linked (manually, by entering the key value of the second result into a new field for that record) but then I am not certain how to take that record and pull the results into a new table... I am assuming query but not sure how. Also, it would seem this method would duplicate the process since there would be two keyed records linked to each other by this process and reported in the new table.
Importing a table that lists the two products and their test results on one line, but I have no way of relating this to the result key since that is imported to the database in a separate import which assigns the keys. Also, if I went this route, I could just evaluate the results in this csv negating the need to automate this. Although I could still link them and have it stored there.
Any guidance or suggestions are appreciated