SELF JOIN & Master Record Deletion

[ron G]

I have a portal based on a self join (stocks) table.

The portal is based on stocks2 and works well. However, I have an "X" button on the portal row to delete the portal row but unlike my other portals (which are based on regular tables related to STocks), when I press the X on STock2 to delete the row I was surprised to get "Do you want to delete the entire master record or just his one related record."? Deleting the Master Record deletes ALL ENTRIES in the portal .. wow!

I would like the portal row to be quietly and quickly deleted without user 'approval' or a message.

BTW, IN THE RELATIONSHIP JOIN, I HAVE TURNED on and OFF [color:red]"Delete Records in this table when records are deleted in the other table" without apparent consequence or affect.

DO I have to dig up the error code, trap for it, and ignore it??? Or, is there an easier way?

As you can tell, this is my first experience with 'self joins'.

Thanks

[bruceR]

None of what you're saying is relevant.

The command you want is delete portal row.

[LaRetta]

None of what you're saying is relevant.

I think it was QUITE relevant and nicely explained.