Dropdown choice eliminated from selections
in [Queries]
|
Prev: Final Reminder - Microsoft Responds to the Evolution of Community
Next: Delete records from second table
From: Erinayn on 28 May 2010 14:54 I have a simple scenario... We have a list of 20 items and I'd like people to identify the top 10 to them. I created a dropdown but was wondering if I can make it so that when they used one of the rankings if it can be removed from the choices.
From: PieterLinden via AccessMonster.com on 28 May 2010 17:37 Erinayn wrote: >I have a simple scenario... > >We have a list of 20 items and I'd like people to identify the top 10 to >them. I created a dropdown but was wondering if I can make it so that when >they used one of the rankings if it can be removed from the choices. Say you have two tables tblItems(ItemName) and tblChoices(PersonID, ItemName, Rank) You need to set the rowsource of your combobox to SELECT tblItems.ItemName FROM tblItems LEFT JOIN tblChoices ON tblItems.ItemName = tblChoices.ItemName WHERE tblChoices.PersonID = Me.cboPersonID AND tblChoices.ItemName IS NULL ORDER BY tblItems.ItemName -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/Forums.aspx/access-queries/201005/1
From: PieterLinden via AccessMonster.com on 28 May 2010 17:39
Erinayn wrote: >I have a simple scenario... > >We have a list of 20 items and I'd like people to identify the top 10 to >them. I created a dropdown but was wondering if I can make it so that when >they used one of the rankings if it can be removed from the choices. Say you have two tables tblItems(ItemName) and tblChoices(PersonID, ItemName, Rank) You need to set the rowsource of your combobox to SELECT tblItems.ItemName FROM tblItems LEFT JOIN tblChoices ON tblItems.ItemName = tblChoices.ItemName WHERE tblChoices.PersonID = Me.cboPersonID AND tblChoices.ItemName IS NULL ORDER BY tblItems.ItemName -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/Forums.aspx/access-queries/201005/1 |