Alright I know I should be ashamed, well I am, I need a little help. What I want to do is have a form that lists some info on server hardware that has a filtered select list on it.Basically I want to choose a manufacturer (HP, IBM, Dell...) and when I choose the manufacturer the Models are populated for the specific Manufacturer. Example I choose HP in a select menu the next select menu is populated with Proliant 123, Proliant 234, Proliant 345. So inturn what is the best method for the DB design, a single table like
ID, man_ID, manufacturer, mod_id, model or should I split them Manufacturer table man_id, manufacturer Model table mod_id, model, man_id I know this is somewhat simple but I am just having a brainfart this morning. For testing and client approval I am making it in Access but eventually I will recreate this in Oracle. -- Tim Blankenship [EMAIL PROTECTED] ********************************************************************** You can subscribe to and unsubscribe from lists, and you can change your subscriptions between normal and digest modes here: http://www.productivityenhancement.com/support/DiscussionListsForm.cfm **********************************************************************
