Jump to content
  • 0

Multi-Layer Relationship



Hello Caspio Gurus!


I have an action log, and in this action log I have three Foreign Key user fields - Assigned, Creator, Completer. (all three which point at tblUser)


How might I go about displaying all these users in one report?


I tried creating views (qryUserAssigned, qryUserCreator, & qryUserCompleter) and using those views in a view, but I can only use tables when creating a view.


Any help will be greatly appreciated.


Link to comment
Share on other sites

3 answers to this question

Recommended Posts

  • 0

Hello CHAD,


I am afraid, that the best way is to use three tables Users.

You can use Scheduled Tasks to export the Base of three tables and then Import it two times to replace the second and the third tables.


As far as I know, many-to-many relations do not work now in Caspio.


But maybe there is a better solution.

Link to comment
Share on other sites

  • 0

I have several (I think over 7 or 8) Many to Many relationships functioning happily within Caspio.


The key is to build a third table that only houses the many to many relationship.


Granted, this could slow your entry process for Action Logs as it would require three separate entries (though you could automate it pretty quickly to keep the same "feel" of a single form with a few auto-submit forms afterwards) but it would allow you to indicate what users are related to that table and your many-to-many table would need a field to indicate the relationship type.


Then you can craft a view that will have (in your case) three rows for each Action Log, each indicating a specific user. Through the use of calculated fields you could easily make a datapage report that would show you all three on a single report.


Hope this helps!

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...