EONE BLOG

Creating a Joined List In Popdock – Knowing The One to Many Relationship


When you are creating a joined list in Popdock there are a few factors that need to be considered. With any join, you need identical data, preferably a unique identifier. This means one column in each list contains identical data that can be joined on. In some cases, you have one list with a unique identifier and another list that has multiple matches for that unique identifier. A good example of this is a sales list with an invoice number, and a sales item list with multiple items that match on the same invoice number.




One invoice can have multiple items on it. This is called a “one-to-many” relationship. When joining lists with a “one-to-many” relationship in Popdock, you have to add the list with the many data points first. This is because Popdock will first list each item in the sales item list and join on the invoice number to the sales list to get the data needed for each item.  Although this causes the Total field to show duplicates for each line item, you can remove the field and create your own calculated field that multiplies the Quantity and Unit Price.




If you didn’t join with the sales item list first, you would end up with a sales list joined to the data from the sales item list. However, it would only match to the first sales item in the list that the join found that matches. You would also be missing the additional items data for each invoice that had more than one sales item.



This makes it important to understand a “one-to-many” relationship, and the reason for adding the “many” list first as the primary list, then add the “one” list second. This is necessary to get the correct data you need and not miss any important data for your list.

If you have any questions regarding joining lists in Popdock, please reach out to support@popdock.com so that our Support Team can assist you with creating the list with the data you need.

Leave a Comment





RECENT POSTS


Missed the Q4 Partner All Hands Call? It's Not Too Late!
2019 End of Year Promotions
SmartConnect Bootcamp in Houston, TX
Last Chance! Join the Partner All Hands Call Tomorrow!
Tech Tuesday: Setting up a Basic Authentication Service in SmartConnect.com

POPULAR POSTS


2016 SmartConnect Integration Bootcamps
Tech Tues: Automatically refreshing Pivot Tables in Excel Refreshable Reports
Happy Thanksgiving from the eOne team!
New Releases of Extender and SmartList Builder
2017 SmartConnect Integration Bootcamps

CATEGORIES

ARCHIVES

open all | close all

TAGS

Business Central CRM Dynamics 365 dynamics crm Dynamics GP Dynamics NAV Econnect Employee Spotlight eone eOne News eOne Spotlight Events Excel Excel Report Builder Extender Extender Enterprise Flexicoder GP GPUG integration Meet the Team Microsoft dynamics crm Microsoft Dynamics GP Office Relationships partners Popdock release Reporting SalesForce SalesForce.com scripting SmartConnect SmartConnect.com SmartConnect Bootcamp SmartConnect Office Hours SmartList SmartList Builder SmartList Designer SmartView SQL Support Tech Tuesday Templates training Zendesk

Integrate & Automate without Any Code.

SmartList Data has Never Been Faster.

The Easiest Way to Report on GP Data.