There are two modules: Module A and Module B.
In Module B, from a functional perspective, we need to relate a field to Module A and auto-populate a few field values from Module A based on the record selected from the lookup.
Relate To: Using a formula, we can't auto-populate values.
To achieve the above, we need to create a relationship.
- 1:1 Relationship: The downside is that a new table is introduced, which increases the volume of data. If we need to write a query, the number of joins will also increase.
- 1:M Relationship: Similar to the 1:1 relationship, a new table is introduced, increasing data volume and joins in queries. Additionally, from a functional perspective, we don't need a subpanel, but it would still need to be hidden via Studio or JavaScript.
Could you please guide us on the correct approach? Should we add a 'Relate To' field and auto-populate values via code, or should we add relationship fields, considering their drawbacks? This is a very common scenario, so any insights would be appreciated.