Hi I am working on a project where I need to empty the data stored in a few of the tables within the larger database.

It is a judical database where some tables define judical codes, which will stay the same so those do not need to be cleared out, its just tables containing offender data from that past year.

Does filemaker have a method which will empty the data in a defined table, if so how does one go about performing this operation? I am very new to FM and any help would be greatly appreciated.

Zebe:

Welcome to the Forums.

Clearing a table is fairly simple, and you can do it manually or via a script.

Doing it manually is this simple:

1. Go to a layout which shows records from the table in question.

2. Go to Records->Show All Records.

3. Go to Records->Delete All Records.

You will get a dialog box asking if you really want to do this. Be sure you've got the right table before continuing.

You can write a script to do the same, and it would have the exact same three steps in it; you can set the Delete All Records script step to function without the dialog box for ease of use, but it's obviously a fairly dangerous script to leave lying around.

-Stanley

Perfect! Thanks so much for your help! I found FM to be a little expansive and confusing at times when first beginning to learn it capabilites.

Thanks again for the help!