Situation: Table 1 is information about a test, table 2 is rather spreadsheet with test results over discreet intervals. Tables share a testCode (autonumbered in table 1, integer in table 2). All other columns in test results have appropriate "Not Run" default values.<BR><BR>Question: How do I perform an ALTER TABLE such that a constraint is made to add every new record in Table 1 to Table 2?<BR><BR>(in script, this would simply be:<BR><BR> insert into [table 1] ...<BR> insert into [table 2] (testCode) values (" & NEW_TEST & ")<BR><BR>where NEW_TEST references the newest test in table 1. This approach, however, means that there&#039s spots for anomalies which I don&#039t want...)<BR>