Deleting Items from an Index

April 2, 200718 yr

Newbies

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

April 3, 200718 yr

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?

April 3, 200718 yr

Author
Newbies

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