Value list problem
FM 12 adv. I have been using a value list to display names but to insert foreign keys, However, the list of names has gotten very long, so I tried switching to a value list of active records only. The inactive names no longer appear in the records! Apparently, a value list does not make permanent changes to records. How can I make sure the foreign keys are permanently inserted?