Jump to content
  • 0

Multiple Relationships



Hi All, 

I've two tables in my Caspio account. One Table with product information (IMEI, Serial Number, Order Number, Product Name... and so on. The products have a IMEI or Serial Number. I use the order entry as unique key in the table.  
I registrate the products that are sent back (IMEI, Serial Number, Products and so on.). I use the retournumber as unique key in the table

Now my question is: 
How can I get information from both tables? I tried to make a view with a double relationship (IMEI from one table to the other and Serial Number from one table to the other).
This seems not to work..?

Is there any option to use information from both tables in one view or datapage?

Link to comment
Share on other sites

1 answer to this question

Recommended Posts

  • 0


Well, it is not very clear what is actually wrong with the tables. You have described the design for the first table, but not for the second. Also, it is not very clear what for should the resulting view be used. Also, did you check the guide on creating views? https://howto.caspio.com/tables-and-views/what-are-views/creating-a-view-to-join-tables/

Generally speaking, if tables have compatible fields as primary (unique) and secondary (non-unique) keys, you can create a relationship between them. Then, it is pretty easy to create a view.

Also it is a good idea to design your database in a proper way to avoid tables having same set of data or one big table having non-relevant data. Here is a small article with tips on table design:


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...