P
paul
Hi all,
The scenario is this; I have a client who visits site to offer a kitchen
installation service. Whilst there he notes on a piece of paper the things
that need doing, however insted of writing 'They need a new worktop' for eg,
he has a system that cross matches a number with a description, ie a worktop
= 12. He walks through the whole proposal process this way till he has a
long shopping list of numbers.
He then brings this list back to the office where he gives it to his
secretary who then types up a standard quote by referring his numbers to a
book (yes a book!) which has the write up of each number. This write up
could be anything from a 10 word sentance or a 300 word block of text.
We are now managing to bring him into the IT age and have compromised that
he carries on visiting site walking through and writing down numbers, but
insted of the secretary typing each one out, insted can work from a database
which will pull in the client details and then allow the secretary to select
from a drop down list (or something) the numbers, one at a time, he has
written down each one making a seperate sentance/paragraph. After this she
would be able to export the file to a word document to be stored safely on
their new network, and obviously to be sent out to the client in the form of
a quote.
Has anyone seen a database out there that might do the job, or any ideas how
to get started in creating one. I'm not an access developer but 'know my way
around' so any ideas would be really appreciated.
Many thanks
Paul
The scenario is this; I have a client who visits site to offer a kitchen
installation service. Whilst there he notes on a piece of paper the things
that need doing, however insted of writing 'They need a new worktop' for eg,
he has a system that cross matches a number with a description, ie a worktop
= 12. He walks through the whole proposal process this way till he has a
long shopping list of numbers.
He then brings this list back to the office where he gives it to his
secretary who then types up a standard quote by referring his numbers to a
book (yes a book!) which has the write up of each number. This write up
could be anything from a 10 word sentance or a 300 word block of text.
We are now managing to bring him into the IT age and have compromised that
he carries on visiting site walking through and writing down numbers, but
insted of the secretary typing each one out, insted can work from a database
which will pull in the client details and then allow the secretary to select
from a drop down list (or something) the numbers, one at a time, he has
written down each one making a seperate sentance/paragraph. After this she
would be able to export the file to a word document to be stored safely on
their new network, and obviously to be sent out to the client in the form of
a quote.
Has anyone seen a database out there that might do the job, or any ideas how
to get started in creating one. I'm not an access developer but 'know my way
around' so any ideas would be really appreciated.
Many thanks
Paul