Duplication in Primary Keys

I have run into a problem regarding multi-column keys that periodically pops up in the news group.

I have a child table that has references to 2 tables that both use location as an identifying key.

IE:

LOCATION_TABLE:
PK
LOCATION_NBR WORK_SPACE_TABLE:
PK
LOCATION_NBR
WORK_SPACE_NAME WORK_ORDER_TABLE:
LOCATION_NBR
WORK_ORDER_NBR WORK_ORDER_PROGRESS_TABLE:
PK
(FROM THE WORK_SPACE_TABLE)

LOCATION_NBR
WORK_SPACE_NAME
(FROM THE WORK_ORDER_TABLE)

LOCATION_NBR
WORK_ORDER_NBR
PROGRESS_DATE_TIME The problem is the location comes from 2 different keys that have to have the location as the primary keys. I am uncomfortable with this, but it seems I don't have a choice without surrogate keys. Any solutions?

Christopher L. Lupton
Data Tech, Inc.
Indianapolis, IN

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Tue Jun 23 1998 - 11:45:37 CDT