Greg58 0 Posted October 31, 2020 Share Posted October 31, 2020 I have tried to find the answer to this but cannot. I have a HOUSE Table (parent) and an OCCUPANT Table (child). I have a portal on the HOUSE layout showing the occupants for a particular house. When I delete the occupant, it also deletes the occupants record!! I do not have the delete box checked in the edit relationship dialogue box. I have attached the file. Thanks for any assistance. HouseOccupantExampleForumQ.fmp12 Link to post Share on other sites
comment 1,817 Posted October 31, 2020 Share Posted October 31, 2020 (edited) Yes, deleting a portal row means deleting the child record shown in that row. There is nothing else to delete: a portal row has no existence of its own. If you want to remove the occupant from the portal and keep the occupant record as an orphan, you need to empty the house ID field in the occupant's record, not delete the portal row. 10 hours ago, Greg58 said: I do not have the delete box checked That box serves a different purpose; when checked on the Occupant's side, it will delete all child occupant records when you delete the parent house record. IOW, it makes sure there are no orphans left in the child table when a parent is deleted. Perhaps you were thinking of a different situation, where a person can live in more than one house. In such case there would be three tables - and deleting the record joining a person to a house would not affect the person's record itself. Edited October 31, 2020 by comment 1 Link to post Share on other sites
Greg58 0 Posted November 9, 2020 Author Share Posted November 9, 2020 Thanks Comment. That clears this up for me. Link to post Share on other sites
Greg58 0 Posted November 29, 2020 Author Share Posted November 29, 2020 Sorry but still having a problem with this. I have tried several methods to remove the employee from the portal but not delete the child record, but having no success. Would you mind having a look at the example file please?? CompanyEmployee.fmp12 Link to post Share on other sites
comment 1,817 Posted November 29, 2020 Share Posted November 29, 2020 Does this work as expected? CompanyEmployee2.fmp12 Link to post Share on other sites
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now