AnsweredAssumed Answered

Another way to add and remove database relationships?

Question asked by disabled_dconnect on Jan 24, 2014
Latest reply on Jan 27, 2014 by disabled_dconnect

Title

Another way to add and remove database relationships?

Post

     Hi,

     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?

     Thanks

Outcomes