OK, I am not a db admin type. I have a knowledge of html, php and very little mysql but am learning.
What I really need is guidance on design/structure of my possible database.
Let me explain as best I can what I need.
I have a vehicle appraisal business. We do vehicle appraisals. I would like to have the appraiser input into the database the following areas:
appraisal number (could be PK - auto generated
type of appraisal (this will trigger some other fields to be filled in if necessary
date of visit/appraisal
client name, address, phone, email
Vehicle Make, model, body style, color, interior color
mileage of vehicle
the following comments:
engine and comparment
body and exterior
I would like to get a printed report out from this. Also, have it saved so I can reference them later.
I probably think that this could be done in excel but would like to have it web accessible - mysql could do that in my webpage later.
I also figure that this could be a "flat file" (see, I have researched some things) but this is the start of a bigger endevour that I see but cannot figure out as of yet and don't want to make a start only to have to rebuild completely because the "foundation" was not correct.