AnsweredAssumed Answered

Dealing with inactive records

Question asked by SteveKeiser on Jun 27, 2013
Latest reply on Jun 27, 2013 by SteveKeiser


Dealing with inactive records


     Is there any reason for not doing the following: 

     Make a duplicate of a table. Make a field that is a calculation field that always equals the value of an inactive record. Then relate the duplicated table to the original matching the calculated inactive field to the inactive field as not equal. The duplicated table then excludes all inactive records. If this is okay to do, it would simplify a lot of my scripts.

     Perhaps this is what is commonly done, and I only now thought of it----but since I have not seen it done, I am curious if this will create some type of problem.