I am unable to enforce referential integrity for the relationship MPN_Id to MPN_id, all fields types are Short Text
The main table SPD1 was received with all records, say 1000 records
The Id fields in this main table SPD1 are currently blank or has a value that is held in the look-up table (I had already started populating before creating the enorforced integrity)
The two look up tables as shown hold the unique values
The two relationship are both to show all data in SPD1 and only the data that matches the look up table and are 1 to many
I am able to create the enforce referential integrity for the Comment_Id to Comment_Id, BUT not for the MPN_Id/MPN_Id
The idea is that when I populate the Id in the SPD1 table, its corresponding look-up data will be brought in
Any ideas WHY I am unable to enforce the integrity, as I cant see any difference in data or relationship??