title: Can't figure out how to make this form
body: <p>I am trying to make a scheduling system using PHP and MySQL.  I have it so i can view/edit/delete employees, equipment and customers.  The final thing I need to do is make the schedule.  I have the following tables</p>
  
  <pre><code>-- Lookup table for employee positions.
  CREATE TABLE `EmployeePosition` (
      `EmployeePositionID` INTEGER AUTO_INCREMENT NOT NULL,
  `Name` VARCHAR(100) NOT NULL,
  CONSTRAINT `PK_Position` PRIMARY KEY (`EmployeePositionID`),
  CONSTRAINT `UK_Position_Name` UNIQUE (`Name`)
  );
  
  -- Lookup table for eqipment types.
  CREATE TABLE `EquipmentType` (
  `EquipmentTypeID` INTEGER AUTO_INCREMENT NOT NULL,
  `Name` VARCHAR(100) NOT NULL,
  CONSTRAINT `PK_EquipmentType` PRIMARY KEY (`EquipmentTypeID`),
  CONSTRAINT `UK_EquipmentType_Name` UNIQUE (`Name`)
  );
  
  -- Employee information.
  CREATE TABLE `Employee` (
  `EmployeeID` INTEGER AUTO_INCREMENT NOT NULL,
  `Email` VARCHAR(100) NOT NULL,
  `FirstName` VARCHAR(100) NOT NULL,
  `LastName` VARCHAR(100) NOT NULL,
  `EmployeePositionID` INTEGER NOT NULL,
  `HomePhone` VARCHAR(32),
  `CellPhone` VARCHAR(32),
  `AccessLevel` TINYINT NOT NULL DEFAULT 0,
  `IsDisabled` TINYINT NOT NULL DEFAULT 0,
  `PwdHash` CHAR(40) NOT NULL DEFAULT 'X',
  CONSTRAINT `PK_Employee` PRIMARY KEY (`EmployeeID`),
  CONSTRAINT `FK_Employee_EmployeePositionID` FOREIGN KEY (`EmployeePositionID`)     REFERENCES `EmployeePosition` (`EmployeePositionID`),
  CONSTRAINT `UK_Employee_Email` UNIQUE (`Email`)
  );
  
  -- Customer information.
  CREATE TABLE `Customer` (
  `CustomerID` INTEGER AUTO_INCREMENT NOT NULL,
  `Name` VARCHAR(100) NOT NULL,
  `Address1` VARCHAR(100),
  `Address2` VARCHAR(100),
  `City` VARCHAR(100),
  `State` VARCHAR(2),
  `ZipCode` VARCHAR(20),
  `Phone` VARCHAR(32),
  `Fax` VARCHAR(32),
  `IsDisabled` TINYINT NOT NULL DEFAULT 0,
  CONSTRAINT `PK_Customer` PRIMARY KEY (`CustomerID`),
  CONSTRAINT `UK_Customer_Name` UNIQUE (`Name`)
  );
  
  -- Equipment information.
  CREATE TABLE `Equipment` (
  `EquipmentID` INTEGER AUTO_INCREMENT NOT NULL,
  `Number` VARCHAR(32) NOT NULL,
  `EquipmentTypeID` INTEGER NOT NULL,
  `IsDisabled` TINYINT NOT NULL DEFAULT 0,
  CONSTRAINT `PK_Equipment` PRIMARY KEY (`EquipmentID`),
  CONSTRAINT `FK_Equipment_EquipmentTypeID` FOREIGN KEY (`EquipmentTypeID`) REFERENCES   `EquipmentType` (`EquipmentTypeID`),
  CONSTRAINT `UK_Equipment_Number` UNIQUE (`Number`)
  );
  
  -- Basic job information.
  CREATE TABLE `ScheduledJob` (
  `ScheduledJobId` INTEGER AUTO_INCREMENT NOT NULL,
  `CustomerID` INTEGER NOT NULL,
  `JobDate` DATETIME NOT NULL,
  `ReportTime` DATETIME NOT NULL,
  `StartTime` DATETIME NOT NULL,
  `JobDescription` MEDIUMTEXT NOT NULL,
  CONSTRAINT `PK_ScheduledJob` PRIMARY KEY (`ScheduledJobId`),
  CONSTRAINT `FK_ScheduledJob_CustomerID` FOREIGN KEY (`CustomerID`) REFERENCES  `Customer` (`CustomerID`)
  );
  
  -- Employees tied to jobs.
  CREATE TABLE `ScheduledEmployee` (
  `ScheduledEmployeeID` INTEGER AUTO_INCREMENT NOT NULL,
  `ScheduledJobID` INTEGER NOT NULL,
  `EmployeeID` INTEGER NOT NULL,
  `Notes` MEDIUMTEXT,
  CONSTRAINT `PK_ScheduledEmployee` PRIMARY KEY (`ScheduledEmployeeID`),
  CONSTRAINT `FK_ScheduledEmployee_ScheduledJobID` FOREIGN KEY (`ScheduledJobID`) REFERENCES `ScheduledJob` (`ScheduledJobID`),
  CONSTRAINT `FK_ScheduledEmployee_EmployeeID` FOREIGN KEY (`EmployeeID`) REFERENCES `Employee` (`EmployeeID`),
  CONSTRAINT `UK_ScheduledEmployee` UNIQUE (`ScheduledJobID`, `EmployeeID`)
  );
  
  -- Equipment tied to jobs.
  CREATE TABLE `ScheduledEquipment` (
  `ScheduledEquipmentID` INTEGER AUTO_INCREMENT NOT NULL,
  `ScheduledJobID` INTEGER NOT NULL,
  `EquipmentID` INTEGER NOT NULL,
  `Notes` MEDIUMTEXT,
  CONSTRAINT `PK_ScheduledEquipment` PRIMARY KEY (`ScheduledEquipmentID`),
  CONSTRAINT `FK_ScheduledEquipment_ScheduledJobID` FOREIGN KEY (`ScheduledJobID`) REFERENCES `ScheduledJob` (`ScheduledJobID`),
  CONSTRAINT `FK_ScheduledEquipment_EquipmentID` FOREIGN KEY (`EquipmentID`) REFERENCES `Equipment` (`EquipmentID`),
  CONSTRAINT `UK_ScheduledEquipment` UNIQUE (`ScheduledJobID`, `EquipmentID`)
  );
  </code></pre>
  
  <p>The form i am trying to make should look something like this:</p>
  
  <pre><code>+-------------------------------------------------------------------------------------------------
  ScheduledJobID  JobDate  ReportTime  StartTime  CustomerID EmployeeID  EquipmentID  JobDescription
  +-------------------------------------------------------------------------------------------------
  </code></pre>
  
  <p>CustomerID, EmployeeID, EquipmentID should all be dropown boxes that I can choose from information already in the
  database.  I am not sure where to start...Can someone help me please.  I do know how to make the dropdowns as i already use them
  in my add forms.</p>
  
  <p>Basically i want to show the job date, time to report to the office, time to report to the customer (StartTime), The customer we are working for,
  The employees on the job, the equipment on the job, and a job description....We are a service company and this is how we schedule.  We currently
  do it on paper and I am trying to get us into the 21st century.</p>