How can I delete records in a Filemaker Pro 6 database

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

OR

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.
tferro999Asked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

rogierCommented:
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?

goodluck
rogier

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
tferro999Author Commented:
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.
rogierCommented:
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

goodluck
rogier
Learn SQL Server Core 2016

This course will introduce you to SQL Server Core 2016, as well as teach you about SSMS, data tools, installation, server configuration, using Management Studio, and writing and executing queries.

tferro999Author Commented:
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?


rogierCommented:
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

rogier.
lesouefCommented:
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.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
FileMaker Pro

From novice to tech pro — start learning today.