AnsweredAssumed Answered

Table Relationship Problem

Question asked by hobbiesdeveloper on Oct 3, 2012
Latest reply on Oct 4, 2012 by hobbiesdeveloper

Title

Table Relationship Problem

Post

     Hello,

     I encountered some problems with my table relationship not correcting showing all the necessary records. I currently have List( order_polineitem_VENDOR::CompanyName ) inside a Custom Dialog Box and it's showing only 3 out of the 4 Vendors with Company Names.

     I have included a picture of the Table Relationship for this problem. Everything is linked correctly but for some reason not all the PO Company names are showing up.

     It's currently showing this in the Customs Dialog message box.

     John, Inc (UT)
     John, Inc (FL)
     John, Inc (PA)

     It's getting this information from the Vendors associated with the polineitem which is associated with the order.

     It's supposed to show:

     John, Inc (UT)
     John, Inc (FL)
     John, Inc (PA)
     John, Inc (PA)

     I have 4 Purchase orders not 3, we added an extra John, Inc (PA) which it's not showing up in the list.
      

     I'm not sure why it's only showing the 3 PO's out of the 4 PO's.

     If there is anything else you need please let me know and I will be happy to post just to get this problem resolved.

      

     Thanks.

ScreenHunter_14_Oct._03_12.58.jpg

Outcomes