Problem with relations

[Bob Fitz]

Let us know how you get on

[PoorCadaver]

Hi again!

This syntax:
SELECT Computer.ID, Computer.Type, Computer.Room, User.Name FROM [User] INNER JOIN Computer ON User.ID=Computer.User;

How do I add another column, i e the room?

Jonas

[Bob Fitz]

Try this SQL:

SELECT Computer.ID, Computer.Type, Room.Room, User.Name FROM Room INNER JOIN ([User] INNER JOIN Computer ON User.ID=Computer.User) ON Room.ID=Computer.Room;

Don't forget to change the "Room" control from a combo box to a Text Box.