26-03-2009, 19:38 | #1 |
The Last Airbender
Join Date: Jun 2006
Location: Pigmopad
Posts: 11,915
|
Business Customer and Order System - Creating from scratch
This is something I've always wanted to get up and running here at work, but we've never had the money to be able to buy something in.
What we need is actually fairly simple. A customer database that holds, business name, address, tel numbers, etc. We also then need a jobs database that holds specific job information on product type, amount, colour, etc. I then need to be able to link jobs to customers. We don't really need anything overly complicated but I really don't know where to start. I'd like to use a mysql backend with a web front end. I'm happy using Dreamweaver so I can customise the front end to what we want, but how easily can I get the database up and running? Can I add form fields in DW and allow it to take care of sorting the database? (after some initial setup obviously). I don't know if it's something I could teach myself, or if I'm biting off more than I can chew or even living in cloud cuckoo land in thinking that it's possible for me to do this way. Are there any examples out there I can take a look at or use as a starting point?
__________________
|
Thread Tools | |
Display Modes | |
|
|