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.
I have been in this industry for 6 years and such jobs are my daily practice. This is my first time on this site and hence you can see that I have only 8 ratings/feedback to show you. I can assu Daha Fazla
Bu iş için 3 freelancer ortalamada $182 teklif veriyor
I can do this job for you. you can consider that it is done. I am a statistician and an expert in using Microsoft Access. let us discuss in PM