New to TOAD, forgive me .... I have a database with drop downs, I can see them in my tables in Toad for MySQL (child tables?).
As an example: I have a list of officer names x 15 in the child table, these show up in a drop down in the 'front end' (or customer end). I want to remove some of the officers (or unlink them) so they they don't show up in the drop downs. I did try and delete one, and while it did disappear from the drop down - it deleted that person from all previous entries (which I need kept).
Is there a way I can perhaps 'unlink' it using Toad for MySQL so that it doesn't show up in the drop down list but all the historical information is kept.
Given the agency I work for I can't share any screens, sorry!
As I mention above, very new to this so any help anyone can give would be really helpful, think of the 'pub test' when talking to me.