Recent content by jdrighter

I realize there are several threads already dedicated to this particular topic but my situation is slightly different... First, my tables are set up like so: tblStudent(studentID,LName,FName,MI,Gender) tblRack(rackID,roomID,studentID,rackNumber) tblRooms(roomID,roomNumber) There are 3 racks...

Thanks for the reply ScottGem. I think I got it worked out.

Trying to set up a fairly simple DB. Here is the layout: tblRoom(roomID, roomNumber, rackOne, rackTwo, rackThree) tblStudent(studentID, name) Each student will be assigned to one, and only one, rack. There will be 3 students to one room. One student can only have one room but a room can...

I have set up the following tables: tblLicense(LicenseID, LicenseName) tblStudent(StudentID, FirstName, LastName, UnitID) tblUnit(UnitID, UnitName) tblStudentLicense(StudentID, LicenseID, IssueDate, ExpirationDate) For the tblStudentLicense Table, I am using the LookUp wizard for StudentID and...

I'm pretty sure I followed the table setup. Thank you for the time, it is much appreciated! j

Greetings, I was hoping someone could offer some advice on how I would design the following project: Student Table - ID - Name - Unit (each student belongs to one specific unit) - License type (each student could have multiple license types) Unit Table - Unit Name (string) License...