Making a Non-Unique ID

[kpcollier]

Hello. I am trying to make an automatically generated sequential ID system that is NOT Unique. 

I need to have duplicate records with the same ID in the same table. Is there any way to do this?

[Harbinger]

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

[kpcollier]

@Harbinger, that is magnificent. I just got into the office and going to try to implement this right now. Appreciate the help!