Thanks, heaps @Jeremy_Oglesby.
I get where you are coming from, to an extent - but I’ll try and explain in more detail to try and get my point across.
On our website, we have people that are registering their interest in joining our program.
You can see the form they fill in here: https://www.parkigrocer.com/register-your-interest
Each of these fields corresponds to an airtable field on our ‘registered interest’ table. This table, essentially, contains all the customer information.
We take their phone number as part of this.
I have the SMS block setup to send messages to customers based on their mobile numbers.
They will also start making re-occurring payments each week for their fruit box.
When they make a payment or reply to a message, there is going to be a one (customer) to many (messages and payments) relationship.
Therefore, I need to set up a messages and payments table in addition to my ‘registered interest’ (customer) table.
My question really is, when I receive a payment or a message I need to write them to the ‘payment’ or ‘message’ table.
Using ‘messages’ as the example (as I presume payments will work the same way), when a message comes in I will write it to the messages table. In that table will be a messages field that contains the message.
So, now I have a ‘messages’ table full of records with messages received at different times and a ‘registered interest’ table full of customers.
Now, I’d like to pull up a customer’s details by expanding their record in the ‘registered interest’ table and within that detail screen see their entire history of messages that have been written to the ‘messages’ table.
My question is, what is the correct way to link these tables to get this functionality to work as I’ve explained, and what other detail do I need to write to the ‘messages’ table when a message is received in order to get this functionality? And I presume the same for payments?
Thank you for your help and patience!