I need a database creating, in an open source technology that can be in time added and edited as required.
At the moment, i need the DB to have the facility to do the following:
I need a customer information area, ie customer name address contact details etc. Need to be able to add/remove/edit this info
I need to have a form where I can add the following information,
Date Returned (Short Date Format) DD/MM/YY
Customer (Selected from Drop Down List from customer info)
Product Barcodes (Multiple Product Barcode information)
I also then need to be able to have reports for data mining this information.
FOr example, how many returns between 1 date and another
How many returns and details of barcodes by customer
you get the idea.
I want this to be completely open, no copyrights of any sort so i am free to develop at my will.
I am open to offers regarding DB technology.