Related Field for Relationship

Discussions for the HanDBase for iPad and it's conduits and desktop add-ons

Related Field for Relationship

Postby fsbof » Thu Feb 19, 2015 4:11 am

Hi,

I have had mixed success with Relationship fields.

For example if I select as the source of 'Related Field in the Database',a PopUp type field it doesn't seem to work.

Also if I select as the source of 'Field in Other Database', a Unique type field it doesn't seem to work. However if I do a calculated field in the other database which is FLOOR(<Name of Unique field>) as integer and then use this as the "Field in Other Database' it works fine.

Is there any list of which types of fields work with in the various Relationship options please?

Thanks
fsbof
 
Posts: 40
Joined: Fri Apr 19, 2013 9:28 pm

Re: Related Field for Relationship

Postby Brian_Houghton » Thu Feb 19, 2015 6:34 am

Hi,

You can use text, integer, float and calculated and conditional fields with relationship fields.

Make sure you choose like types in both the parent and the child.

Hope this helps.
Kind Regards,
Brian Houghton, DDH Software
Brian_Houghton
 
Posts: 2246
Joined: Wed May 20, 2009 8:30 am

Re: Related Field for Relationship

Postby fsbof » Thu Feb 19, 2015 8:24 am

Hey Brian,

Thanks that is perfect. I simply added a conditional field to each database where the result was always (both if and else) the value of the Popup field and then repointed both of the matching fields in the relationship and it all sprang to life. Awesome, thanks so much. Reminded me to go an post a review on the Appstore too!

Thanks
fsbof
 
Posts: 40
Joined: Fri Apr 19, 2013 9:28 pm

Re: Related Field for Relationship

Postby Brian_Houghton » Sat Feb 21, 2015 11:08 am

Glad to be able to help, and thanks so much for the review! It is greatly appreciated.

If you have any other questions please let us know.
Kind Regards,
Brian Houghton, DDH Software
Brian_Houghton
 
Posts: 2246
Joined: Wed May 20, 2009 8:30 am


Return to HanDBase for iPad

Who is online

Users browsing this forum: No registered users and 1 guest

cron