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.