PoorCadaver
Registered User.
- Local time
- Today, 09:16
- Joined
- Oct 25, 2011
- Messages
- 30
Hi,
Searched the forum but could not find this. If I double posted, please show me the correct thread.
I have tblComputers with a column 'user_id' that corresponds to column 'id' in tblUsers. I want to view column 'user_id' in a listbox in tblUsers in a form with various other data from tblComputers so that I can assign the computer to a user. Very basic.
I can do that via the wizard but when I select a user in the dropdown, the tblUsers updates the current id with the new. It overwrites a usernam with the new one I selected and I don't want that. I want it to update 'user_id' in tblComputers with the new id.
How can I do that?
Searched the forum but could not find this. If I double posted, please show me the correct thread.
I have tblComputers with a column 'user_id' that corresponds to column 'id' in tblUsers. I want to view column 'user_id' in a listbox in tblUsers in a form with various other data from tblComputers so that I can assign the computer to a user. Very basic.
I can do that via the wizard but when I select a user in the dropdown, the tblUsers updates the current id with the new. It overwrites a usernam with the new one I selected and I don't want that. I want it to update 'user_id' in tblComputers with the new id.
How can I do that?