AnsweredAssumed Answered

Returning Database values

Question asked by PaulStringer on Jun 26, 2014
Latest reply on Jun 26, 2014 by PaulStringer

Title

Returning Database values

Post

     Hi,

     I have a One to Many Database.  I have a Customers Table with a CustomerID.  I then have the following tables all linked via the Customer ID:

     OrderHistoryDetail
     OrderHistoryGroup
     PaperOrderHistory
     Contacts
     DiaryNotes

     I'm designing an iPhone Layout and I am able to return values from all of the tables except the Contacts and DiaryNotes.  When I go into the Table View the 2 columns relating to the information I am trying to return are completely blank (but columns relating to the other tables are fully populated).  I have tried all of the columns from the 2 tables but it fails to return information from any columns within the Tables.

     I've attached a screen shot of the relationship along with the information it is returning behind it,

     Any advice on how to resolve this issue would be greatly appreciated

     Regards

     Paul

FileMaker.PNG

Outcomes