[AccessD] DB Design Question

Did you ever get any responses to this and do you still need help?

Susan H.

>
> 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.
>