Jump to content
  • 0

List of things, which in turn have properties



2 answers to this question

Recommended Posts

  • 1


In my opinion it is a good idea to have a lookup table for such cases: it is simple to set up and it is really scalable: you can add or remove some entries without need to review all the data. Try using Relationships for that: https://howto.caspio.com/tables-and-views/relationships/creating-and-managing-relationships/

Once you set up the database relationships, it will be possible to use readable values, but store numbers in the table.


Link to comment
Share on other sites

  • 0

So does that mean in the User ID Table, I would have to have multiple entries for just one user? (See example below)

But then the problem would be, I would have to make User Name and User Email non-unique. 

How do I then prevent duplicate users from registering? 


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