Linking / Relationship question

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

Linking / Relationship question

Postby VelvetLounger » Mon Jun 04, 2012 2:41 pm

I have three tables that I have linked.

Sites \
Logins
Devices /

Both Sites and Devices are separately Link/Linked to Logins, and both tables are able to create new login information. Normally when you link from either parent table you can only see the logins that were created by that parent table.

I want to be able to start at the Sites table and create a link that shows me all logins regardless of which parent table created the login information.

Starting from the Sites parent table, is there a way to use the Relationship field to create a way to view all Logins records regardless of which parent table was used to create the record? This would just be used to view all logins, and not create new ones.

I have tried creating a conditional field in the Logins table that looks at both Linked fields. If one Linked field is empty it fills in with the data from the other. I have then tried using the Relationship field to link to the conditional field. But this does not seem to work.

Any suggestions would help

Thanks
Using HanDBase since I had my Palm 3.
VelvetLounger
 
Posts: 105
Joined: Thu Dec 15, 2011 7:47 pm
Location: Chicago, IL

Return to HanDBase for iPad

Who is online

Users browsing this forum: No registered users and 1 guest

cron