How can I delete records in a Filemaker Pro 6 database

Posted on 2006-04-21
Medium Priority
Last Modified: 2012-05-05
I know almost nothing about filemaker and I need to add the functionality to delete records in a simple database.

Nothing fancy, just a few fields, the whole DB is only 500k in size and is only for a single user.

I can create a new button but I can't seem to get it to do much for me.  When I go into the layout mode and specify the options for my button, do I use a Control>>Perform Script>>Delete Record


Do I use Records>>Delete Record/Request

I have tried both of these but when I go back into browse mode the button doesnt do anything.  Forgive my stupidity, I have only been using filemaker for about an hour now.

Any help would be greatly appreciated.   Perhaps someone knows of a good tutorial to guide me through this.
Question by:tferro999
  • 3
  • 2

Accepted Solution

rogier earned 1500 total points
ID: 16515251
You can simply use "delete record/request" and assign that to the button. You can also set options such as "perform without dialog".

if you prefer you can write a script that deletes the record (and perhaps does a couple more things for you) which can also be triggered by clicking a button. In that case - as you describe - you use the "perform script" option.

finally you can also hit ctrl-E to delete records, when you are in browse mode.
try that first. Silly question maybe, but are there any records selected when you hit the button?


Author Comment

ID: 16516110
What needs to be done after I assign the button to "delete record/request"?  I tried this earlier but the button didnt seem to do anything.  

I'll try it again along with the Ctrl+E on Monday.

Expert Comment

ID: 16516137
nothing in particular is required after that. You have to have an active record and a current found set, i.e. you may need to choose "show all records" from the menu first. If there are no records at all (although I remember you wrote you have records in the file), you need to make a record first. And the button needs to be on the active layout. But that all speaks for itself, of course.

have a look here: http://www.filemaker.com/downloads/documentation/fmp_tutorial_files.zip

or here: http://www.filemaker.com/downloads/documentation/fmp_tutorial.pdf

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.


Author Comment

ID: 16527905
Do you know why the "Delete Record" icon is grayed out, the CTRL+E function does not work as well.  This database was password protected, and I do have a valid logon, but maybe not enough permissions to delete records?

Any other databases I create, I will see the "access priveleges" under the File menu.

Is this as simple as not having admin rights on the db?


Expert Comment

ID: 16537852
yes it sounds like you're not having the privileges to delete records. Filemaker works with sets of privileges that you can create and link to groups of users. So it's not necessarily "admin rights".

I suggest you contact the developer or owner of the database to unlock the files

LVL 28

Expert Comment

ID: 16538968
don't forget a read only file does the same but keeps silent. it obviously is not yr problem since the menu record delete cmd is greyed out.

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Pop up windows can be a useful feature of any Filemaker database.  Though best used sparingly, they can be employed in a multitude of different ways, for example;  as a splash screen at login, during scripted processes to control user input, as pick…
Having just upgraded from Filemaker 11 to Filemaker 12 over the weekend, we thought we would add some tips for others making the same move.  In general, our installation went without incident. Please note that this is not a replacement for Chapter 5…
Whether it be Exchange Server Crash Issues, Dirty Shutdown Errors or Failed to mount error, Stellar Phoenix Mailbox Exchange Recovery has always got your back. With the help of its easy to understand user interface and 3 simple steps recovery proced…
Is your OST file inaccessible, Need to transfer OST file from one computer to another? Want to convert OST file to PST? If the answer to any of the above question is yes, then look no further. With the help of Stellar OST to PST Converter, you can e…

840 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question