Error in Relationship Field

For HanDBase related topics that are not specific to one platform.

Error in Relationship Field

Postby riaboner » Tue Aug 12, 2014 5:24 pm


Our project is using HanDBase on Ipods. We have two linked databases, ArbolesXTerritorio as the main parent form and Phenology as the additional information child form. We use a relationship field in the Phenology to deliver a value from the ArbolesXTerritorio "Plot" field to the child form when the link/linked values match between the forms. We have chosen the first match found, however this distinction should not be too important.

When we create a record, the "Plot" value is correctly displayed in the Phenology form on the Ipod. However when we sync and open the Phenology database in HanDBase Desktop the value displays in this file as ERROR!. When we sync the data to Microsoft Access, the value displays correctly again in Access.

We save all of our HanDBase files as back ups and would prefer that the error value did not show as such. What steps can we take to resolve this issue?

Thanks in advance for any help you can provide.

Posts: 2
Joined: Tue Aug 12, 2014 5:05 pm

Re: Error in Relationship Field

Postby dhaupert » Wed Aug 13, 2014 1:22 pm

Hi there,

Thanks for your question. So if I'm understanding correctly, the iPod shows the relationship value correctly but the HanDBase Desktop version does not? If I have that right, a few followup questions for you:

- Is your desktop computer Mac or Windows? Assuming Windows since you mentioned Access, but want to be sure!
- Are you sure that the ArbolesXTerritorio database and the Phenology are present in the same folder on the desktop?

Thanks in advance for your response!
Posts: 4113
Joined: Tue May 26, 2009 11:51 am

Return to HanDBase General Discussion

Who is online

Users browsing this forum: No registered users and 3 guests