Thank you, I can see how that would make things easier. I am far enough where restructuring will be a little painful but not impossible.
So lets now assume that I have a single table to search, DevicesT. How would I search the table, matching the devices that are assigned to the owner, change...