When I use a script, as in Query Analyzer, there does not seem to be a problem.

When I open Table1 in Enterprise Manager (return all rows), then put the cursor in the TT1D1 data entry field and enter somthing, then there is a problem. The problem corrects itself if 'run' is invoked on Table1.

The planned interface for the original developement DB (where the problem 1st appeared) is currently an MS Access project. In there, entering data in the problem field produces an error which requires the form to be refreshed to correct.

Remember that before the problem presents itself, an entry must be made in Table2, unassociated with Table1.