I'm afraid you have to be a little more specific about the data structure (tables, relationships).
Also, there is no such thing as a Delete button.
There is a button object that can perform actions, including Delete Record or Delete Portal Row. The latter is the one you need.
Are there any relationship that can cause deletion of related records?
Same question as Fabrice...just in different words...
In the relationships between tables, on which sides of which relationships is the "Delete related records in this table when a record is deleted in the other table" checkbox checked?
1 of 1 people found this helpful
The layout based on Architects uses two files and a copy. Architects & Architects~Self ALL linked using Global field set to 1
Architects~Self ALL is used as a portal to list architects
A second portal is created from a copy of the TimeSheet file linked to Architects as shown.
When a line from the first portal is selected the Name Global is updated with the name of the selected architect.
The delete button referred to is a single step "delete portal row" in each row of the timesheet portal.
There is a Global field outside the portals where a date can be selected. This restricts the time sheet display to a single day using the portal filter.
I have written a script to delete a single line in the timesheet portal using the ID to locate in the timesgheet file.
It also deletes all the records in the timesheet file
Your screenshot is quite clear: all timesheets with the same name will be deleted.
What you show does not appear to be the only relationship between these tables. You need to check each one for that delete option. It sounds like, somewhere in your relationship graph, you have a delete option selected that should not be selected.