Jump to content

wickjes

Members
  • Posts

    1
  • Joined

  • Last visited

Recent Profile Visitors

The recent visitors block is disabled and is not being shown to other users.

wickjes's Achievements

Newbie

Newbie (1/14)

0

Reputation

  1. What is the best way to manage data when you have multiple entries that need to go into any one attribute cell? I'm doing curriculum mapping in Caspio. I’ve got my data tables set up and my relationships mapped out. However, I don’t quite understand what you would do when you have multiple entries for any attribute cell. For instance, maybe I have 3,000 lectures. For each lecture, I might have anywhere between 1 and 15 program objective tags I want to attach to it. I already have a table for my lectures and a table for my program objective tags. But, the column in my lecture table that references related program objective tag keys allows just one tag entry in each row's cell. One of my friends who’s worked lightly with databases told me you have to add multiple rows for each additional tag, so you might just put each lecture into your table 15 times so that you can tag it with each of the 15 program objectives you need to be attached to it or whatever. Maybe that truly is the only way, but it seems like it would create an unnecessary and astronomical workload involving duplicate data across the course of my 3,000 lectures...turning my data entry woes into more like 6,000-9,000+ lecture entries in my table. To me, it seems like that kind of defeats the purpose of using a database, but maybe I just don’t understand. Any insight? I've watched the relationship videos and they don't clearly speak to this issue with a high volume of entries. Thanks!
×
×
  • Create New...