1:1 Relation Fields

Summary I know that you can make a 1:1 relation indirectly by making a 1:m or m:1 relation and defining one side as unique. (It is automatically a 1:1 because a unique boundary is created on both sides). But a 1:1 could actually be much more than just a representation that you create a 1:m relationship. For example, you could automatically display the data on the same page (e.g. displayed as a field). When you enter the data record, a group is displayed completely on the same page. In addition, if the main data record is deleted, you would not have to worry about whether the attached data record still exists in the background or not. This would then also be deleted automatically. Further small enhancements and simplifications could be built in ... but more on that later, if anyone has any ideas. Translated with DeepL.com (free version) Basic Example Example: I make a field that has a 1:1 relationship. One or more fields are automatically created in the table that have…