June 2, 200718 yr I have seen other similar topics already but they didnt help. I have a point of sale system with a portal. With products and stuff etc... I want to have a button outside of the portal which will delete the last transaction on the portal. But when i make a script which highlights the previous transaction and then the delete portal row, it deletes the entire point of sale for that particular sale! Plz help.
June 2, 200718 yr As you have 8.5 Advanced I assume you've used the debugging tools - running the script step by step and monitoring values. Why not post your script on the board.
June 3, 200718 yr Author Go to Portal Row [select; Last] Go to Portal Row [select; Previous] Delete Portal Row [] It automatically creates a blank record underneath the last product so I have it set to the last then the one above and then want it to delete that row. I want this button to be outside the portal. With the script now, when i press the button it highlights the right portal row and asks if i want to delete this one record, i click yes but then it deletes the whole thing. Edited June 3, 200718 yr by Guest
June 3, 200718 yr If you manually delete a portal row, does it delete the parent record? This would indicate the parent side of the relationship has the option checked to "Delete related records in this table when a record is deleted in the other table". This is what Reed was asking about (but you didn't answer).
June 3, 200718 yr Author Yea I didnt understand what he meant, Thanks that fixed it though. I think my IT teacher told me to tick that, idiot... lol
June 3, 200718 yr You do probably want to tick the box on the other side of the dialog, so that portal records get deleted when the parent record is deleted. Just not the other way around.
Create an account or sign in to comment