I have a continuous form with all records from the table Main. It's purpose is for a supervisor to be able to correct a record if needed. Each record could potentially also have data on 2 related junction tables. I have added 2 Edit buttons on each record/row on the continuous form in case they need to add or remove something from the junction tables.
The Edit buttons open up a form with Main as the record source, which has a continuous child subform based on the junction table. There are comboboxes that show what is already present and a blank one to add new ones, and then behind each combobox is a delete button.
One of them is working how I'd like, to delete only the one item from the junction table where they clicked Delete. It says "You are about to delete 1 record." and only deletes from the junction table. The other one is deleting the record from the junction table as well as from the Main table. The incorrect one says "Relationships that specify cascading deletes are about to cause 1 record in this table, along with related records to be deleted."
I do have cascading deletes set up in the relationship, because I wanted anything deleted from Main to also delete from the junction tables. But I don't want anything deleted from the junction tables also deleted from Main. Why is one doing it and one is not? The relationship is exactly the same. I have compared the working subform to the non working one and cannot find any differences. What am I missing? Is there a better way to do this so they aren't deleting things by accident? Or a better way to let them edit a record on Main as well as add or remove things from junction tables? The junction tables only have ID numbers and not descriptions, so they need a something like a combobox that shows them the description of what they are adding or removing.
Any help would be greatly appreciated!
The Edit buttons open up a form with Main as the record source, which has a continuous child subform based on the junction table. There are comboboxes that show what is already present and a blank one to add new ones, and then behind each combobox is a delete button.
One of them is working how I'd like, to delete only the one item from the junction table where they clicked Delete. It says "You are about to delete 1 record." and only deletes from the junction table. The other one is deleting the record from the junction table as well as from the Main table. The incorrect one says "Relationships that specify cascading deletes are about to cause 1 record in this table, along with related records to be deleted."
I do have cascading deletes set up in the relationship, because I wanted anything deleted from Main to also delete from the junction tables. But I don't want anything deleted from the junction tables also deleted from Main. Why is one doing it and one is not? The relationship is exactly the same. I have compared the working subform to the non working one and cannot find any differences. What am I missing? Is there a better way to do this so they aren't deleting things by accident? Or a better way to let them edit a record on Main as well as add or remove things from junction tables? The junction tables only have ID numbers and not descriptions, so they need a something like a combobox that shows them the description of what they are adding or removing.
Any help would be greatly appreciated!
