Wasting days on this problem.
In the portal for Table A, I want to create drop-down fields that select or create records in Table B.
No matter what I do I can't seem to get the database relationship right.
From the relationship graph select the table to have the created records made in and make sure you put a check next to the option to create records .
Amazing. Thank you. I had allowed for creation - what I hadn't done was select the delete related record. For some reason everything now works.
The allow delete records check mark should not have been a factor in creating records.... Hmmm.
Yes, the delete is separate and optional. I usually enable it and have a delete link in a portal field by itself.
Retrieving data ...