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