hotsam

Hi, Below is a picture of my database tables, and their relationships. I was hoping someone might have a quick look and tell me if I'm on the right track, or if I need to: Change PRIMARY keys Change INDEX / FOREIGN keys Change Table Structures Also, I'd like to add a table that stores the various CALIBERS that firearms are available in. I'm thinking the relationship would be many-to-many, as a firearm can have many calibres, and a calibre is available for many firearms...? How would I make the CALIBRE table? What fields should the table contain, and how should it relate to the FIREARMS table? I'd like to be able to output a list of firearms, and show available calibres for each of those firearms. Just to help out, the database will be used to: - search for firearms and their available calibres - show retailers that sell a particular make of firearm - show reviews that owners (users) submit. These will be shown alongside each firearm searched for http://forums.xisto.com/no_longer_exists/ Thanks for any help! Jarrad

Hi,I'm sure I'm on a well worn path here. I've looked through the forum for answers but I can't seem to find what I'm looking for.I'm a newbie, I'm mid 40's, hacked of with bosses, given up 9 to 5, taught myself how to design sites using MS Visual Web Developer (html, asp.net, vb etc) - but I AM VERY MUCH A NEWBIE, and I've started my own freelance company. I've only built one site so far (even my own site is one of those free site builder things you get with your domain name). I'm going to get myself going by building cheapo semi-static stuff for local small businesses, then I'll get into the sql stuff, then make my millions by building my own stuff.Anyway, my problem is, given that all my initial clients are going to be utterly web illiterate, how can I avoid being tethered to their sites forever in order to perform the info updates they're bound to want? What I would like to be able to offer clients is a hidden page wherein they can login and access an integral CMS and perform content changes without me having to get involved. I'm looking for something that is preferably free, or cheap, but primarily reliable. Is there such a gizmo? and where do I find it?By the way - hi everybody!Michael

I was thinking about having a go at Designing a template for WordPress or a forum CMS, I never done one before and I like having a go at new things. What forum and blog CMS are the best/ easiest to start with? I was thinking phpbb 3 or 2. Thanks Oliver -------------------- CssFx Web Gallery Is Now Open! - Submit your site now! 500 Posts I'm Coming for youu!! DarkNotes http://www.darknotes.net/