0 Replies Latest reply on Feb 8, 2016 7:59 PM by MartinBishop

    Join/Relationship Build Help


      I am trying to understand the best route in building a new database...

      Previously I had made a similar database with a one-to-one relationship using a portal to filter items, but it appears with lots of records this can be very slow. My assumption is that using a join table would speed this up.


      So here are two records I am working with:


      1.     Planes (Main Table)

      a.     Related Items (Items Table)

      2.     Tanks (Main Table)

      a.     Related Items (Items Table)


      Each related item has a different color combination.

      I am looking to relate these items from the gDropdown field, but In addition I would like to see “Show All” or “All Yellow” included into the menu.


      Issues I see with this:


      1.     Creating a new record from (Main Table)

      a.     Having gDropdown set at Show All will add this as a relationship, though this is more of a filter. Items should only be related by specific color combination (Colors Table)

      b.    Maybe I need to use a Script to create the new record to avoid this?

      On the (Items Layout) I am selecting the related (Colors Table) from a portal dropdown, but is there a way to use checkboxes?


      Hope that makes sense... In the end I am trying to achieve an easy way to see what Planes or Tanks use the same colors quick and easily.