I am working on a project that requires me to link up multiple tables in my database together so it would be more efficient for the front end to grab that information. While linking up my table I encounter a problem. My app originally was designed so that there can be only one judge per case, however, I need each case to have multiple judges. At first, I ponder as to what is the best way of solving this issue. At first, I tried turning all the judges names into a string but then realized that it will be very difficult for the front end to find the id of each judge. Next, I tried making a new copy of the case for each one of the judges but then I then realize that will be very difficult to sort and it may return duplicate data. Finally, I remembered a solution my old instructor taught me, "just make another table". I made a new table linking all of the judges to the case and called it judges_to_case. Now, whenever I join the two tables together I can link them both with my new Judges_to_case table.
For further actions, you may consider blocking this person and/or reporting abuse
Top comments (0)