Quick Tip: Finding the Right Many-to-Many Relationship When Adding Subgrids
When you add a subgrid to a model-driven app form and select "Show related records", you'll see a list of tables related to your current form's table. For one-to-many (1:N) child tables, life is pretty straightforward. The lookup column name appears at the end in brackets, making it easy to distinguish between multiple relationships with the same table. But many-to-many (N:N) relationships? That's where things get messy. The dropdown just shows the related table name, and if you've got multiple many-to-many relationships with the same table, good luck figuring out which option corresponds to which relationship. Here's a quick workaround that's saved me plenty of headaches: 1. Click the ellipsis (...) at the top and select "Switch to Classic" 2. In the classic form designer, open the subgrid properties (by selecting the subgrid and click Change Properties) 3. Fire up your browser's Developer Tools (F12 or Ctrl+Shift+I) 4. Click the ...
