Drop down option in field
Posted by: Mike Byrne
Date: March 10, 2009 09:24AM

I am currently setting up a database and in one of the fields i want the user to only input one of 5 options (-,D,E,L,S) How do i format the field to allow these options in a drop down box?

The field name is Vote

the SQL is

CREATE TABLE `athy` (
  `ID` decimal(10,0) NOT NULL,
  `Station` varchar(50) NOT NULL,
  `Sname` varchar(15) NOT NULL,
  `Fname` varchar(15) NOT NULL,
  `Address1` varchar(15) NOT NULL,
  `Address2` varchar(15) NOT NULL,
  `Address3` varchar(15) NOT NULL,
  `Address4` varchar(15) NOT NULL,
  `Vote` varchar(7) DEFAULT NULL,
  `Division` varchar(15) NOT NULL,
  PRIMARY KEY (`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;



Edited 1 time(s). Last edit at 03/10/2009 10:41AM by Mike Byrne.

Options: ReplyQuote


Subject
Written By
Posted
Drop down option in field
March 10, 2009 09:24AM
March 10, 2009 10:24PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.