Say a customer ordered 20 items but 3 were out of stock.
I log those 3 items into the database.
I figured out how to use Twilio API to send an SMS text message. I'm looking for an easy way to text the out of stock items to each customer.
I have a main form [frmIssues_View2_Head] with the order details and a subform [frmIssues_View2_Foot] with the product details.
I need to combine some of the header details with all of the product details into a single text box so I can then send via SMS message.
I don't know how to do loop, end of file, programming. If that's even how this would be done.
I'm hoping one of you geniuses could help me out...? Thx so much in advance!