displayed when editing column, selection, or other fornulas, reducing the
usifulness of the list? Ever wanted to get rid of fields you don't want to use
anymore, but find that after deleting them from your forms they still appear in
the list? This is especially a problem when trying to adapt one of Lotus's
overly complicated templates to fit a real-world solution.
Well here is how to clean house:
To remove unwanted fields from the list in the designer, remove all references
to the field from the database and then compact the database.
You can remove unwanted fields from documents by using the formula:
FIELD fname := @Deletefield.
You also have to remove any references to the unwanted field that may appear in
formulas elsewhere in the database. To find references, use the design synopsis.
Once you compact the database, the unwanted fields will be gone from the list.
If they aren't, it's because they are still being referenced somewhere in the
Mind you, this is a time-consuming process, but if you don't have a tool to do
it for you, it will get the job done.