Another way to add and remove database relationships?
Is there a way to change the related fields between two related tables without going into manage database.
I have two big tables 30K records each.
They are both related to each other by a key record that both tables share, so going through both tables can be slow at times.
Sometimes, I don't need all the records to be related, and I add an extra level of relationships, and the databases get a lot quicker to go though.
The issue is I can't have staff going into the manage database admin.
Is there a way to add and remove this extra relationship without admin privileges?