This may be as much a layout design issue as it is a relationship issue. I don't think enabling a delete option on any of these relationships is a factor I can't conceive of any way that could be a factor. The allow creation option is a key clue here I think, but it comes down to how you've set up your layouts for this.
I suspect that you are using portals for data entry--which is how I would do it, but the fields, the portals or the layout on which the portal is located refer to the wrong table occurrence and thus have to "force" a creation of a record in a related table to permit the creation of a new record in the portal when you enter data.
Describe the layout where you are encountering this problem. In Layout Setup..., there's a drop down called "Show Records From". What table occurrence is listed in it? Describe each portal on this layout and what Table occurrence is listed in "Show Records From" in portal setup... for each of these portals. Check and see if the fields in which you are trying to enter data refer to the same table occurrence as the portal. If they do not, indicate what table occurrence they refer to.
Thank you very much for the "AH HA" moment! You were absolutely correct.
The portal was still referencing records from "Line Items" TO - Not the "Line Items for Donated Items" that it was linked to on the table chart. (I should be more careful when duplicating Layouts)
Very simple fix once I set the portal to pull from the appropriately linked Table.
It's been a long time, but going back into this database for a little modification.
Can I have a combined CONTACTS Table that would consist of both Buyers and Donors (see original post in this thread)?
Should I replace both the BUYER Table and DONOR Table and replace with one CONTACTS Table?
What would be the easiest way to accomplish this?
My reality is that for this solution, it is very common for me to have someone donate money or an item but that same person also will purchase another item donated by another person. It would be great to have ALL MY PEOPLE in one place but still be able to assign them both a Donor Receipt for money or items AND a Buyer Invoice for something they purchase.
Any thoughts? Thanks in advance.