On Tue, 21 Sep 2004 18:08:37 -0600, "Maureen Smith"
wrote:

I am not quite understanding what I'd need to do. This is my understanding
of the table structure you suggest.

Turn your understanding "sideways".

tblServType would have ONE field - ServType.

tblServSubType would have two fields - ServType and ServSubType.

Rather than putting service into fieldnames you would store them as
*values in the table*. Reread rpw's suggestion in this light and see
if it makes more sense.

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps