Assuming I have a Database/Transparent Table named ZICEVEHICLES. Currently, I can create multiple entries of CAR ID with single car engine ID.
Ford Fiesta - 1.0 Ecoboost( Accepted entry)
Ford Fiesta - 1.5 Ecoboost( Accepted entry)
Ford Fiesta - 3.2 Duratorq Diesel.( Accepted entry)
Ford Ranger Raptor - 3.2 Duratorq Diesel (I tried adding this but since the Car Engine ID is a Key Field, the entry wont be accepted)
It is possible to change the key field into Car ID so I can create like this?
Ford Fiesta - 1.0 Ecoboost
Ford Focus - 1.0 Ecoboost
Ford Ranger Raptor - 1.0 Ecoboost
Ford Raptor - 1.0 Ecoboost
Lastly, this is a custom table and is being used by other custom program. How do I check if changing the keyfield of a transparent table will affect other programs?