Jump to content
  • 0

Making a Non-Unique ID


kpcollier
 Share

Question

2 answers to this question

Recommended Posts

  • 0

Hi @kpcollier,

I am afraid that it is not doable in the current design of the platform yet. However, you may try to use this work around as an alternative.

You may create a different table and established relationships.

e.g.

 

Main_table                                                                                           Child_table

Field              Data type                                                    Field            Data type

ID_Main               Prefixed_autonumber                                         ID_Child         Text(255) if the Id contains an alpha or special character 

Name                     Text(255)                                                                                                  Integer if contains an int only.

 

                                                                                             (   Primary_Key | Foreign_Key | Comments )

     

Then after,  you can now establish a relationship within these tables and use the "ID_Main" field as your display value. You may check the colors above for Primary_Key and Foreign_Key  reference.

Alternatively, if you wish to use those tables in your DataPage, you may use Views to join them and use the newly created view as your Data source in your DataPage.

You may check this links for reference: https://howto.caspio.com/tables-and-views/what-are-views/creating-a-view-to-join-tables/   |    https://howto.caspio.com/tables-and-views/relationships/

I hope this helps.

 

Cheers,

H

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.

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

Loading...
 Share

×
×
  • Create New...