Making records inactive

Discussion created by dvrazel on Sep 11, 2017
Latest reply on Sep 12, 2017 by DanielShanahan


I have a question. I have a file that has several records in it that are used in drop down menu in a different file.  For example, we use FM for quoting different instruments.  These instruments are tied to pricing in a certain file (Instrument Cost Lists) so that you can choose them in the quote you are making and choose from a drop down menu.  We have some instruments in the drop down menu and Instrument Cost Lists file that are now obsolete but I don't want to delete them (for record keeping).  I would like to make them inactive.  How would I go about designating certain records in the list that are inactive so that they either don't show up in the list or they do show up but are inactive or a different color to show they are inactive?  Can anyone help me with a suggestion?