I’m trying to setup something that will be using the API to write the data to records, but I am trying to figure out the best way to organize the data to begin with.
Basically, I have customer records that are viewed by hotels, restaurants, bars, etc., and the venues want a way to add notes to a customer and view all the notes for that customer. Eventually I want to have permissions around who can view which notes, but for now I’m just trying to have a list of notes that ties to one field in another table.
The data is organized in Table 1 with the primary field being a member #, and one field for “Notes”. Table 2 has the primary field also by member # (really just a list of numbers though), and the columns contain repeating sets of Note+Date/Time+Author. There is no defined limit to how many individual notes (columns of 3) a member might have linked to their account.
What would be the appropriate way to link the Notes field in Table 1 to the corresponding Notes Row in Table 2, such that I could view all of the data in the row?
Thanks so much for your help,