I am working on a database to keep track of the hardware and the software inventory of the company I work for.
The "main" table is the workplace table which basically only holds the WorkplaceID, WorkplaceName and RoomNumber. It is linked in a one-to-many relation hip to the PC table which holds all the hardware information on the PC. The workplace table is also linked in a many-to-many relationship to the user table which holds the names of the users.
Now in the PC table I have got the WorkplaceID as a foreign key, but I changed it into a bombo box in the form that displays the workplace name instead. The problem with this that you don't always know the workplace but the name of the PC's user and the combo box can get very long. What I would like to do is have a button that runs a query that lists all workplaces and the users working there. But now it starts getting tricky: From that query I would like to "export" a workplace to the PC form (say double-click on it which closes the query and enters the name into the form).
Can anyone tell me how to do this?
Thx
The "main" table is the workplace table which basically only holds the WorkplaceID, WorkplaceName and RoomNumber. It is linked in a one-to-many relation hip to the PC table which holds all the hardware information on the PC. The workplace table is also linked in a many-to-many relationship to the user table which holds the names of the users.
Now in the PC table I have got the WorkplaceID as a foreign key, but I changed it into a bombo box in the form that displays the workplace name instead. The problem with this that you don't always know the workplace but the name of the PC's user and the combo box can get very long. What I would like to do is have a button that runs a query that lists all workplaces and the users working there. But now it starts getting tricky: From that query I would like to "export" a workplace to the PC form (say double-click on it which closes the query and enters the name into the form).
Can anyone tell me how to do this?
Thx
