• I decided that maybe I should check my idea of only allowing one record at a time to be attached to a form to make sure that it is really not pulling the whole table and that is the case.  Opening the linked tables and attaching a form to a linked table is bad.  Filtering, not so bad.  I used Profiler to check.

     

    Aunt Kathi Data Platform MVP
    Author of Expert T-SQL Window Functions
    Simple-Talk Editor