OP, YOU were instrumental in the code that displays the records in the db (link above) and for that I am grateful.
It works! I was delighted when I saw it mirror my db.
What I was then hoping to do was put a couple of links underneath that table that you can see on the link I sent, links such as 'Add Record', 'Delete Record', 'Modify Record' etc - if you think of an office worker having to do this type of work. On clicking these links a modal/pop-up would appear as a form in which data would be added (or deleted).
The 'Add Record' modal would require its own code in order to add First Name, Last Name, Tel No, etc. Click on 'Add data' - done - job complete.
Having displayed the records on the Web page indicated, this is where I am up to now. That is why I have asked you about 'insert' etc. I feel as if this INSERT page is almost complete, bar one or two errors.
Likewise, the 'Delete Record' modal that would appear when the user clicked on the 'Delete Record' link would require its own code in order to delete First Name, Last Name, Tel No, etc.
The modal part of things (size, colour, etc) I can look after and I am not asking you about that, but I am aware that each modal (add, modify, delete, etc) needs to be correctly coded in ASP in order to work.
Can you not see what I was hoping to achieve? The records are now on display in the page indicated. Now I need to add to those records; later, maybe, delete one or two of them; or modify them.
I probably prefer to have each modal/pop-up ('Add', 'Delete', 'Modify', etc, to have its own code and not for all the code to be on the one page - it would be far too confusing (at least for me).
I should have made this clear to you from the beginning and because I didn't, I apologise. I didn't really have a concrete plan.
But can you see now what I was intending?
Sorry for trying your patience.