1. Write a query to query
1a . from cusotmer table, each with booking number
2a . from subform work order that tight to a booking number in 1a.
ie. one booking number can have 1 or more work order numbers
that out put them in tables
2. Write a function or Module ( which ever is correct term) , pickup the mobile hand phone from the query
2a. Connect to an external SMS modem ( Model iTengo , the basic model)
3a. Loop the query table and send reminder message to customer via SMS, informing customter their booking and all work orders in one message. '
3. The function or model will be call upon periodcally via task schedule or a marco time base.