This customer has the following details :

Company Name	<%Response.Write(list.Fields("Company_Name"))%>
Name	<%Response.Write(list.Fields("Name"))%>
Surname	<%Response.Write(list.Fields("Surname"))%>
Address	<%Response.Write(list.Fields("Address"))%>
Postal Code	<%Response.Write(list.Fields("Postal_Code"))%>
Location	<%Response.Write(list.Fields("Location"))%>
Date of Birth	<%Response.Write(birth1)%>/<%Response.Write(birth2)%>/<%Response.Write(birth3)%>
Email	<%Response.Write(list.Fields("Email"))%>
Contact Phone	<%Response.Write(list.Fields("Contact_Phone"))%>
Fax	<%Response.Write(list.Fields("Fax"))%>
Network	<%Response.Write(list.Fields("Vendor"))%>

---

<% SQL="SELECT * FROM Notes WHERE ID_Customer like '"&id&"';" Set list=connection.Execute(SQL) 'We count the number of phones that the customer has dim counter counter=0 While NOT list.EOF counter=counter+1 list.movenext() Wend %>

This customer has <% Response.Write(counter)%> note(s). Click here to see details.

Click on the button to add a new note

<% SQL="SELECT * FROM Phone WHERE ID_Customer like '"&id&"';" Set list=connection.Execute(SQL) 'We count the number of notes that the customer has counter=0 While NOT list.EOF counter=counter+1 list.movenext() Wend %>

This customer has <% Response.Write(counter)%> phone(s). Click here to see details.

Click on the button to add a new phone