Relationships table not saving.

[needhelp007]

Hi. I've been trying to create a link between two different tables which i've put on the Relationships screen. Any type of link made between RepairScheduleID on the one table and RepairScheduleID on the other table disappear when I reopen the database after closing access. This happens if I save, if i don't save it requests me to save then doesn't store the changes anyway.

Ideas? What on earth is wrong?

 

[Pat Hartman]

Are the tables linked? You must define relationships in the database that actually holds the tables.