are you trying to delete the records from the menus, the status toolbar or a script ? Is there any message displayed ?&
I guess you meant you sorted the records in a Layout, not a database.
Sorting should make no difference. I suggest describing the design of your layout and exactly how you attempted deleting a record.
I'm speculating that perhaps you have a layout with a subsummarry part and no body part.
And what do you do immediately before selecting "delete record" from the records menu In order to select a record to delete?
I place my cursor within the line of the record layout. The first cell darkens.
Then I go up to Delete Record.
I have other Databases where I can delete records doing this same thing.
Which is why we explore what is different this time. No error messages appear after to attempt deleting?
Sent from my iPhone
are the permissions different on this table in any way? (account and privilege set)
Phil - No error messages
Beverly - no restrictive permissions, mine is the only account on the computer.
could you try this:
- left-click to the left of the first column of the record
- then right-click the same 'cell', you will get from the context menu Delete Record
- click on Delete Record
Does it work ?
You might also try taking a copy of this file, recovering it and then see if you get the same behavior in the recovered copy.
Sent from my iPhone
Yes, that worked. And now for some reason, I can delete records using the Delete in the menu bar. I quit and reopened FileMaker, not sure why that would have a difference.
Thank you all!
2 of 2 people found this helpful
The explanation is very simple, to delete a record, you need to select it. If you click in a field, you select... a field. not a complete record. I realized that when trying to delete a record is table view: I right-clicked a field, but there were no Delete Record in the context menu.
Once the record is selected, deleting it will work from everywhere, menu. icon, etc.
Please mark the answer as correct to indicate the question is answered.
I must respectfully disagree with this analysis. When you click on a field, you put the focus into a field and this makes the record for that field (or it's parent if this is a related field) the current record. This is exactly the same result as if you left click to the left of the left most column in your table view.
Right clicking something brings up a context sensitive menu. So if you right click a field, you get a list of menu options specific to interacting with a field. When you right-click the left hand edge of the row, you do not put the focus in the field and get a list of menu options for interacting with a record.
But you can delete the record all the same in both cases and sorting/unsorting the records has no effect on whether or not you can delete a record.
Just to be sure that some behavior change hadn't crept in unobserved, I pulled up a table view in FMP Adv 15 and tried deleting records from a sorted or unsorted found set of records after selecting records by clicking into fields. I was always able to make the row where I clicked into a field the current field and Delete records--by either keyboard shortcut or Menu option always deleted that current record.
I must respectfully disagree with this analysis.
And you're absolutely right. I tested again, thing is:
- clicking inside a field makes its record current, so you are able to delete the record, provided you have that permission
- right clicking on a field brings the context menu for the field, you will never get Delete Record
- but afterwards right-clicking at the left of the first column you will get Delete Record in the context menu
Now why wasn't the OP able to delete the record after sorting, I can't explain. I tried and was able to delete a record.
Next time before I open my mouth, eh before I reply, I should check .