Primary key used in two different relationships

[Grady]

Pretty sure in access I was able to use the same primary key in one table for a relationship to two different tables. It appears in Caspio this is not possible? Thank you.

 

[PotatoMato]

Hi @Grady . Are you referring to the screenshot below?

If yes, this is possible in Caspio as long as the data types that you are using are compatible. You may refer to this link for more information: https://howto.caspio.com/tables-and-views/relationships/database-relationships/

 

-Potato

 

[Grady]

Thank you Potato. I have already looked at the relationships help page and both fields are a data type of number. Anything else to check?

[Grady]

Ok this seems unbelievable but I noticed that your relationship line came out of the other side, I tried that and it worked. However, I have at least two more one-to-many from the "main table"? Thanks!

[Grady]

Ok, was able to create the third. Have you seen issues like this that are basically due to the backend site? That what this appears to be to me because it is working fine now. Thank you!

[Grady]

Had to change the data type of my relationship fields so I deleted the relationships, changed them all from number to text and now having the same issue. It let me create two of the four I need but the other four will not create. How long have you been using caspio potato and have you seen this before? Thanks

 

[Grady]

Sure hope this helps others and would like to know if anyone else has seen this. The issue is with the drag and drop to create the relationship. If you  just use the Add relationship button and set it up that way it works fine. Definitely a bug on the back end. 

[Tubby]

It might be a bug with the drag and drop feature then. Because if it works with the add relationship button (which is basically the same function), then it should not be a backend thing.

Can't say for sure as I cannot replicate the issue myself. Thanks for sharing the workaround!

[Grady]

Your welcome. 

Do I need to mark solved or anything?

[PotatoMato]

Hi @Grady. I'm glad that my initial answer gave you an idea. No need to mark post this as solved.

 

- Potato