Multitable searching

"Steve" wrote in
news
Seven tables is a bad idea! Consider using seven identical forms
except for LocationID. Make the LocationID field on the forms
hidden and on each form set the default value for LocationID
appropriate for the location where the form is being used. With
this setup, anytime someone enters data on their form, Access will
automatically assign the appropriate LocationID for the location
where the data is being entered.

This advice is correct. Something I often do when I'm using a single
form to display subsets of data from a single table that needs to be
distinguished by the user is to use different colors on the form for
the different subsets. It might be hard to find 7 memorable colors,
but I've found that users intuitively grasp the color distinction --
they don't even think about it, they just associate it with the
particular data they are seeing, and that in turn helps them to
avoid editing the wrong data.

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/