Lost relationship and can't figure out how to fix it

[aij5036]

I created a database with a few layouts and one table off of a youtube tutorial and when I tried to customize it a little bit more, I inadvertantly screwed up the relationship between one of my layouts and the table that should go with it.  My goal is to have a database for the horses I am training with a tab for the table of training entries I make pertaining to a given horse.  I initially created a HorseIDFK field and related it back to the HorseID from the original layout.  I wanted to make it so that from the Training table layout, instead of using the ID #, the table used the horse's name but now I've really messed it up.  I still have all my training entries, but they are no longer attached to the individual horses (the tabs from the Horse Info layout are empty).  Help?! Thank you!!

[eos]

Did you change the relationship, or the data - either in the horses or the training entries table? If you changed the relationship to use the name, but the related records don't have this name yet, then obviously there is no longer a relationship. You'd first have to define a name_fk in the training table, then update this field by using the existing relationship (based on keys), and then you can switch from keys to names. So, first try to reset your relationship to using keys and see if this helps. If not, maybe post some screenshots of your Relationship Graph and/or the database itself; this makes it easier to figure our your issue.

 

btw, I wouldn't recommend using names, or any data that has meaning outside your database, as keys. Imagine you'll get another horse with the same name as an existing one – now what? Rename the poor beast? (There are other considerations, but this is the most glaring one.)