[AccessD] DB Design Question

Hi Folks:

I'm working on revising a resource directory consisting of
companies/organizations and the services they offer, and would appreciate
any feedback regarding a specific design question I have. 

Each company/organization can have multiple locations. Given that the
locations are currently contained in 20+ separate tables, once for each
service grouping (EX: dogs, cars, birds), and with specific fields for each
service, I'd like to resolve the locations into one table, and link out to
services via a some sort of  relationship. 

For example, the "dogs" table might have the additional fields: breed,
color, weight, while Cars might have: horsepower, tire size, etc.

I'd like to have this system to be as flexible as possible, any hints on how
to relate those service specific fields to the general tblLocation? Note
that each location might could have multiple services associated with it. 

Thanks ... I'm just a bit foggy today and need a second opinion on this
problem.

Larry Mrazek
LCM Research, Inc.
www.lcm-res.com
lmrazek at lcm-res.com
ph. 314-432-5886
mobile: 314-496-1645