I want to add/update/delete records from a table, using a BASE Form. I have created a working form, but the Delete function does not delete the record, although I get the warning about the record being deleted if I continue. The table in question has an associated table view. I find that I can delete records from my table using my form if I first delete the table view. How can I delete records from the table and keep the table view? Thanks.
First test it with deleting a record directly in the table. The form couldn’t delete a record, if it couldn’t be deleted in a table.
If the record could be deleted something is wrong with the form. If the record couldn’t be deleted post the message, which appears.
A view could never stop deleting a record. It could only stop deleting a table or deleting a field in a table.
Robert - Thank you for the reply. What I found is that the record I was trying to delete had a link to it from another table. The Form stopped me from deleting the record, as did my attempt to delete directly from the table, which makes sense, but some kind of clear error message would have helped. I’ll understand what is going on next time. Takeaway: be careful deleting records in table files of a normalized database.
You could set the behavior of a foreignkey in relation design. Special for tables, which are connected as n:m with a third table, I often choose: When deleting a value in main table delete the rows, which use the foreignkey in the other table.
Very helpful, thank you.