tferro999
asked on
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.
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.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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
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
ASKER
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?
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?
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.
I suggest you contact the developer or owner of the database to unlock the files
rogier.
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.
ASKER
I'll try it again along with the Ctrl+E on Monday.