Yes you are on the correct track with this info. If you are importing directly from the CSV then the file format MUST match the database fields. You could write a parser which does the importing for you, this would give you an opportunity to trap crappy data before it hits your DB. CSV has some gotchas, if it is not well formed, dealing with commas in the data, then you are in big trouble. "Form" implies a standardised format otherwise it is just free form text. Never underestimate the power of human stupidity - RAH I'm old. I know stuff - JSOP

I am sorry for my post earlier. I am part of a 3 student development team and the model changed while I was working on it and I had an old version. I have since updated my model and I can get my dropdown to show the rooms that aren't occupied, but when I try to pass the data to the view, I seem to not be sending any data from the database. This is my controller [get] // GET: Residents/Create public ActionResult Create() { //Query database for IsOccupied flag// //Query for EastSouth Wing// var availRoom = db.Rooms .Where(s => s.IsOccupied == false) .Select(r => new { r.RoomNum, r.WingName, }); ViewBag.rooms = new SelectList(availRoom, dataValueField: "RoomNum", dataTextField: "RoomNum", dataGroupField: "WingName", selectedValue: null); return View(); } This is my current [post] create method: [HttpPost] [ValidateAntiForgeryToken] public ActionResult Create(ResidentIncomeModel residentIncomeModel, [Bind (Include ="RoomNum")] Room rooms) { Resident resident = new Resident { FirstMidName = residentIncomeModel.FirstMidName, LastName = residentIncomeModel.LastName, Birthdate = residentIncomeModel.Birthdate, ServiceBranch = (Models.ServiceType)residentIncomeModel.ServiceBranch, HasPTSD = residentIncomeModel.HasPTSD, InVetCourt = residentIncomeModel.InVetCourt, //RoomID = rooms.RoomID, Note = residentIncomeModel.Note }; Benefit benefit = new Benefit { Resident = resident, DisabilityPercentage = residentIncomeModel.DisabilityPercentage, SSI = residentIncomeModel.SSI, SSDI = residentIncomeModel.SSDI, FoodStamp = residentIncomeModel.FoodStamp, OtherDescription = residentIncomeModel.OtherDescription, Other = residentIncomeModel.Other, TotalBenefitAmount = residentIncomeModel.TotalBenefitAmount }; try { if (ModelState.IsValid)

First off, I would like to apologize for my horrible code!!!! I reread my post and I am really embarrassed. But I guess it takes making a fool out of yourself to get better. Thank you for your help. This worked like a champ.