Jump to content
  • 0
lutl88

List of things, which in turn have properties

Question

I have this Table called User. 

User have a list of Interests. I intend to have each Interest have an intensity level - that can be an integer. How do I program it? 

Thanks

Share this post


Link to post
Share on other sites

2 answers to this question

Recommended Posts

  • 1

Hello!

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.

screenshot.png

Share this post


Link to post
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? 

image.thumb.png.b6cd206b1e7c75a27944c7c9e553c7f8.png

Share this post


Link to post
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...

×
×
  • Create New...