Help creating a Form

[aerofuego]

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 extension but many employees working in it.

I just want to create ONE form to add/edit with the following information.

employee LAST/FIRST NAME
employee ROOM NUMBER
employee EXTENSION NUMBER

If this can be done without using any subform, I would appreciate it.

Thanks.

 

[maxmangion]

you can create a query which includes all the fields that you want to input data in, then you can bound your form to this query. However, note that any other fields which you do not include in the query, will remain null.

 

[aerofuego]

Thanks.

Let me try that.

 

[maxmangion]

you're welcome ... if you have any other problems with this matter, just post again!

 

[aerofuego]

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 with that is that I don't want the person entering the information have to use the foreign key because there are hundreds of rooms in the company and knowing what each room number foreign key is might be a real pain.

 

[aerofuego]

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.

 

[aerofuego]

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 you help.

 

[aerofuego]

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 the room number to list on the right(maybe a list box for this) side the employees' last name, first name, and extension number.

On the treeview, I want to be able to add/delete/edit location, room number.

On the right(inside the listbox) add/edit/delete employee, and extension number.

I don't think this is going to be that easy, but any help would be appreciated.

Thanks.