I sorted a database and tried to Delete a record but nothing happened.
If I unsort the database, I can delete records.
It is only with one particular database.
FileMaker Pro Advanced 13
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.
Here is the layout view - a very simple database.
Here is how I attempt to delete a duplicate record. I select "Delete Record", FMP asks if I want to delete the entire record, and I say yes. The database has roots that go way back.
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:
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.
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!
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:
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 .
Those of us who have been active in the community have all done the same from time to time. The key is, as you have done, acknowledge the error gracefully and learn from it. (I've certainly learned a thing or twelve from others here in the forum via this kind of thing myself.)
As to why DaleH was having this issue, I don't know either. It could have been a temporary glitch, a damaged file or some design feature such as a custom menu with it's own unique code for deleting records. Unless he replies back, we may never know.
Retrieving data ...