Search results

Treeview I don't know if anyone can help me out with this, but what I want is a treeview to do the following: List every location(ie. 1th floor, 2nd floor, 3rd floor, etc.) Then underneath each location list all the rooms for that location(ie. 100, 101, 102, etc.) Then when the user click...

I thank you for your help on the other thread. I think, I learned something from it, but instead of cofusing all of you with the information I provided, I just wanted to make it as little trouble as possible. So, I started a new thread based on these three tables only. I thank you again for...

Maybe a treeview would be better for this. The only thing is I have no idea on how to create one. If anyone can help me out with this, based on the three forms, I would appreciate it. I would like to make changes in the treeview. Thanks.

I think that what you suggested is the right thing. The only problem is that If I have to enter the last/first name for THREE employees that work in the same room, every room gets an ID even thought it's the same room. In order for this to work, I have to use the ROOM foreign key. The problem...

Thanks. Let me try that.

tblEmployee EmployeeID pk LastName FirstName tblRoom RoomID pk RoomNumber EmployeeID fk tblExtension ExtensionID pk ExtensionNumber RoomID fk More than one employee works in one room. A room can have more than one extension because different employees work in that room. A room can have one...

Is anyone able to help me out?

If someone can help me out with this because I am having problem setting this up. Thanks.

I am having a little problem with this. I have provided an example of what I am trying to accomplish in my database. If anyone can help me with this, I will appreciate it. Thanks for you help.

Thank you so much for your help, Pat. I think what you suggested should work pretty well. If I need additional help, I will let you know. Thanks again.

Thanks for the reply, Pat. I will make the change that you said. Now, what I am trying to do here is create a database to track packages that are being delivered by the messengers where I work. Let me explain myself I little be more. Lets say someone call because they have a package(envelope...

CompanyID pk (just one company) CompName EmployeeID pk companyID fk roomID fk extensionID fk LName FName LocationID pk RoomNumber (many employees might share same room) PhoneDirectoryID pk ExtNumber (employees might share same extension number) roomID fk ItemID pk ItmName (messengers take...