In Microsoft Access, I need to be able to add multiple lines to a subform?
In Microsoft Access, I need to be able to add multiple lines to a subform based on a record that is saved in another table. Here's the lowdown:
I have a table where I am entering required tests per an ASTM specification. There are multiple tests per each ASTM. I also have another table where I am creating a material master that I need to reference the ASTM standard (to get the required tests) but the testing requirements may differ slightly, I want to be able to use the ASTM standard tests as a "reference" to the tests that need to be conducted by the material master and add the additional information to each line - The problem that I am running into is the fact that there are multiple items per each ASTM - So I am having trouble linking the items - I need to know how to do this...Any suggestions?
Actually, the more I think about it what I really want to do is copy information from the ASTM standard table into the material master table. I don't need a link between the "test information" from each table....Example:
ASTM 123 - requires a chemical, tensile, yield, proof load test.
Material Master 987 is ASTM 123 material so requires those tests but the methods that those tests are conducted are particular to each material master.
What I am trying to do is avoid having to manually look up and add these tests to each material master.
Is there a code that would run this?