Originally Posted by Old Pedant
It would help if you had shown us your SCHEMA. That is, the names and types of at least the relevant fields in the two tables.
It would also help if you showed us your existing web server code. (PHP? ASP? JSP? Or???)
SQL can eliminate the already-used appointments from the records returned, but you still need to use web server code to convert the records to a <SELECT>.
Hi, no problem.
Recipient schema is below:
Title, Forename, Surname, client_urn, add1 - 6, postcode, tel, email, fc, fc_manager, appointment_id
Appointment schema is below:
appointment, appointment_date, appointment_time
I don't currently have any exisiting code for this campaign, and we'r integrating it with a marketing software called XMPie, most of the pages use C# script, but are saved as aspx pages (if this helps?)