Deleting Items from an Index

[SuzWriter]

Hello All:

I am new to this forum. Hopefully I am posting this in the right spot. I have a database with a field that is set to auto complete using previously entered values. I am using this field for the names of current client projects. I would like to delete items from the index when a project is completed. But when I go to the Insert Index menu and try to delete an item, it won't let me do this.

Can someone tell me if there is a way to do this? If I need to just clear the entire Index periodically I am okay with that. It will get reloaded as I enter current projects again.

Thanks

Suzanne

[David Jondreau]

You can't do what you want this way. Previously entered values are previously entered values, you can't delete them, unless you delete the records themselves.

You need to create a value list based on a related field. You'll need to add self-join to the table you want the list to appear, linking the two table occurences by the project id and also by a current 'flag'.

How do you know that a project is current or not?

[SuzWriter]

Thanks for the response. This is just a little record keeping file I created to track all my client work in one file. I used to keep a separate time sheet for each project. But this allows me to better see how much i am actually earning each month. (Sometimes I may work a project for 2 months before it bills, so it is nice to see when the money is earned already.) It is not worth a lot of time to make it do what I want. There are ways to work around it. IF the old values start piling up, maybe I will create a new database every 6 months or so.

And to answer your question, when I bill a project, it is no longer current and won't recur with that project name. The Client listed in the Client field will appear again, but with a different name in the Project field. I just make up a distinctive name for each project.

I have been using FM for my business records since FM II, and it works for me. I am the only one who uses the databases, so no one else needs to understand them. I just keep tweaking them as I learn more.

Suzanne