Here is a sample table: (mine is larger with more columns and of course, different info) Code: id name type desc 0 apple mcintosh blah 1 apple granny smith blah2 2 apple red delicious blah 3 orange florida blah3 4 pear bartlett blah2 5 apple mcintosh blah2 I want to have an input feature on the website so users can submit info. But i don't want them typing apple, Apple, appel, aplep, APPLE, etc for "apple". I want to have a drop down menu to choose what is available (for some fields, not all) Also, I'd like to have it setup so when you choose apple in the first drop down, mcintosh, granny smith, red delicious are the only 3 options in there. I don't know how to set this up in the database either, for reading this info. Basically it is like Auto Filter in Excel. So, some fields will be drop down only, some you can type in (ie the desc field in this example) and some will have many options, but only display those contingent upon what is chosen in the previous, or specific drop down (ie type choices depend upon what is chosen initially in the name drop down). Also the fields that you can type in are to be limited to specific contents and limits (ie 0-9, length of 6 or alpha-numeric length of 30, etc) I would also like the option of en emailed entry if the option is unavailable, so I can manually enter it and the db doesn't get messed up. A "filter" feature that allows you to show/hide coulmns and sort / filter based upon what is in the columns is required. (ie only show rows that have name=apples and then click on desc to sort it ascending or descending) these are the two main features required: search/sort/filter and input, please PM me with a price/timeline and I might have thought of additional features at that time. Thanks!