I have a database that tracks our assets (serialized). I can successfully add groups of items using subforms and this is how the serials are added. But now I want to test a number of these parts.
1. I want to have a table of assets and a table of tests.
2. the test table should have a test number(text), test type(lookup list), test document(Attatchment), and list of assets tested (lookup from table w\multiple values).
What I want to do is create a form that will allow me to associate many assets with a test so that I may querry an asset and see the tests that have been done to it. I have been unable to figure out how to procede. I would want the tester to create a test and add the parts to it. But the challenge is that he will have to sift through 10,000s of serials to find the 20 he is testing. (the tests are batch process, normally a pressure test). It would be easier if he could type or even sort the assets (the assets have an order number entry). I can add a sample of my database if need be.