cordevil95
New Member
- Joined
- Apr 27, 2006
- Messages
- 33
I have two tables: PLANS and LOTS. Here are some of the fields:
PLANS
Model
Subdivision
SquareFeet
LinearFeet
LOTS
Subdivision
Lot
Block
Model
In the table PLANS "Model" and "Subdivision" are a combined primary key (since the same model can be used in multiple subdivisions but I don't want the same model twice in one subdivision). In LOTS the primary keys are "Subdivision", "Lot", and "Block"
I want to find a way to have the "Model" in the LOTS table change it's name if it is changed in the PLANS table. I can't use Referential Integrity because "Model" in PLANS is not a unique index.
Any thoughts?
PLANS
Model
Subdivision
SquareFeet
LinearFeet
LOTS
Subdivision
Lot
Block
Model
In the table PLANS "Model" and "Subdivision" are a combined primary key (since the same model can be used in multiple subdivisions but I don't want the same model twice in one subdivision). In LOTS the primary keys are "Subdivision", "Lot", and "Block"
I want to find a way to have the "Model" in the LOTS table change it's name if it is changed in the PLANS table. I can't use Referential Integrity because "Model" in PLANS is not a unique index.
Any thoughts?