Hello.
I am slowly learning more and more about access and its various abilities. I suspect i am moving more towards a PHP and MySQL based solution with this question, but i will ask it anyway.
I am looking to create a projects database, where there are employee's who have projects, and clients who create projects. The system would allow the client to register their own username and password, and once they have done that they can log into their own account, update their details etc. What i would then like to do is allow the client to create a project, and within the project they could pick the samples they want to submit to be tested, as part of that project. In addition to the tests each sample required.
The idea is that they enter lots of sample information, for example the label on the sample they are submitting, composition, product name, end use, test required etc and the system registers that against the project they created. It would then once the project is confirmed, send a report PDF to the client by email, with all of the sample information, the project code etc, and barcodes so that the client can attach that to the samples themselves.
When samples are shipped to us, we scan in the project and it would show all samples that were suppose to be tested, and we pick the ones that arrived, and if they are all there, the project can continue, if they are not it would email the client a missing samples, and received samples report.
Ideally i would like to intergrate a payment feature into it, so that for example it would generate an invoice for the samples that need to be tested, and so on.
Does access allow for web based databases like this, or would i really be looking at an ASP custom page, or a PHP custom based page.
Thanks for your comments. I am most interested on if it is possible at the moment, and then if so I can go from there, break it down and look at the individual components etc.
Thanks!
I am slowly learning more and more about access and its various abilities. I suspect i am moving more towards a PHP and MySQL based solution with this question, but i will ask it anyway.
I am looking to create a projects database, where there are employee's who have projects, and clients who create projects. The system would allow the client to register their own username and password, and once they have done that they can log into their own account, update their details etc. What i would then like to do is allow the client to create a project, and within the project they could pick the samples they want to submit to be tested, as part of that project. In addition to the tests each sample required.
The idea is that they enter lots of sample information, for example the label on the sample they are submitting, composition, product name, end use, test required etc and the system registers that against the project they created. It would then once the project is confirmed, send a report PDF to the client by email, with all of the sample information, the project code etc, and barcodes so that the client can attach that to the samples themselves.
When samples are shipped to us, we scan in the project and it would show all samples that were suppose to be tested, and we pick the ones that arrived, and if they are all there, the project can continue, if they are not it would email the client a missing samples, and received samples report.
Ideally i would like to intergrate a payment feature into it, so that for example it would generate an invoice for the samples that need to be tested, and so on.
Does access allow for web based databases like this, or would i really be looking at an ASP custom page, or a PHP custom based page.
Thanks for your comments. I am most interested on if it is possible at the moment, and then if so I can go from there, break it down and look at the individual components etc.
Thanks!
