I want to create multiple forms such as an invoice, document etc where all I need to do is enter a few details such a client name, organisation etc hit 'fill' or 'submit' and it will populate and generate the documents from templates with the necessary information input into the template from the initial form.

What is the best way to do this? Not looking for it to be done for me just need to know what to search for or a link to a video or guide.

SQL definitely works well for this, just be careful about how you architect it. With regards to the post above me, all it takes to destroy his system is for someone to enter something nasty in the search field i.e

Bobby Joe'; Drop table clientinformation;



Just don't forget SQL injection is a thing

True there are some precautions you must take was just giving him a starting point.

In regards to that, you could always put all customer names in a dropdown box that cannot be altered. Many ways to skin that cat, but yeah

Thanks I will try this and see if it does what I need. It can be used to fill a word document or does the template need to be another format

Well, IMO the easiest way would be to write the whole thing in something like Visual Studio or something. Just create the window in a layout like you would want a word document. But there are ways to interact with other windows, including some pretty good stuff to manipulate Office stuff.

I did it through Microsoft word bookmarks and visual basic. Pretty much exactly what I was after.

Only thing is one task is 3 documents and now I'll have to enter same info into each document. Only an extra 30 seconds or so per document but would be great to be as efficient as possible.

Might be able to put all into one document then when printing to PDF only print pages a to b and c to d etc.

Think the next few documents I prepare are bit more complicated do will push me to learn more about visual basic.