i've got a diagram that i've set up. i want it to update because i've made some changes, but now when i go to update from schema it's throwing an error stating "no tables were found for foreign key FK_DIR_Investigation'.
i know exactly where that foreign key is, and as far as i can tell it shouldn't be looking at that relationship. i've tried adding both tables in the relationship but ti still throws the error. is there a way to tell exactly why it's throwing this?