Returning Database values
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:
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