I am trying to tie the different tables in an archaeological database together using Relationships, but I keep getting an error when I try to create one. Can you assist?
An example: “Name” column in ANCIENTITEM to “Lot” Column in Lot Table
This would tie our information for each lot to the ceramics found in that lot.
Error: Column types do not match in statement [ALTER TABLE “Lot Table” ADD FOREIGN KEY (“Lot”) REFERENCES “ANCIENTITEM” (“NAME”)]
Forgive me, I’m not knowledgeable about relationships, keys, etc.