Bethesda Car Rental - Documents

New Project

Add New Item
 
Customers
CustomerID DrvLicNbr FullName Address City State ZIPCode Country
1 W-240-573-885 John Wattson 4024 Locktar Drive Silver Spring MD 20904 USA
2 264-72-6663 Charles Calhoun 10630 Leila Rd #D4 Alexandria VA 22231 USA
3 802-46-4006 Jeannine Pons 802 Mimosa Road NW Washington DC 20006 USA

 

CarID TagNumber Make Model Year Category DVDPlayer CDPlayer Available
1 335-168 Chevrolet Malibou 2008 Full Size Unchecked Checked Checked
2 475075 Hyundai Accent 2007 Economy Unchecked Unchecked Unchecked
3 M247957 Dodge Caravan 2007 Mini Van Checked Checked Checked
4 M466086 Ford Escape 2008 SUV Checked Checked Checked
5 GLL-944 Ford Focus 2007 Compact Unchecked Checked Unchecked
6 M648368 Lincoln Navigator 2007 SUV Checked Unchecked Checked
7 924759 Kia Rio 2008 Economy Unchecked Unchecked Checked
8 M270049 Mazda MPV 2007 Mini Van Checked Checked Unchecked

Control DataBinding -> Text DataSource DisplayMember ValueMember (DataBindings) -> Value (DataBindings) -> Selected Value
cboEmployeeID   BSEmployees EmployeeNumber EmployeeID   BSRentalOrders - EmployeeID
cboCustomerID   BSCustomers DrvLicNumber CustomerID   BSRentalOrders - CustomerID
cboCarID   BSCars TagNumber CarID   BSRentalOrders - CarID
cbxCarConditions BSRentalOrders - CarCondition          
cbxTankLevels BSRentalOrders - TankLevel          
cbxOrderStatus BSRentalOrders - OrderStatus          
  

Control DataBindings -> Text DataBindings - Checked
txtCarID BSCars - CarID  
txtTagNumber BSCars - TagNumber  
txtMake BSCars - Make  
txtModel BSCars - Model  
txtYear BSCars - CarYear  
txtMileage BSCars - Mileage  
cboCategories BSCars - Category  
chkK7Player   BSCars - K7Player
chkCDPlayer   BSCars - CDPlayer
chkDVDPlayer   BSCars - DVDPlayer
chkAvailable   BSCars - Available
txtPictureName BSCars - PictureName  
 

Return Copyright © 2008-2012 FunctionX