473,854 Members | 1,664 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Removing options from droplist once selected

3 New Member
I am a United States Marine. I am creating a data base to prevent the armorers from double issuing a weapon. I have greated a drop list that looks up values (weapons serial numbers) from a weapons table. When the weapon has been selected it is saved in the main table. How do i make that particular serial number not available on the drop list, and to only show weapons that are available for issue?
Jan 7 '12 #1
6 1320
Rabbit
12,516 Recognized Expert Moderator MVP
As the source of the combobox, use a query that left joins to the main table and keep only the ones where it's null in the main query. That will leave only the ones that aren't in the main query.
Jan 7 '12 #2
Luis Del Valle
3 New Member
Rabbit, Thank you for taking your time to answer my question.
What do you mean by "left joins"? Can you please elaborate a little more on your answer.
Jan 7 '12 #3
Rabbit
12,516 Recognized Expert Moderator MVP
Expand|Select|Wrap|Line Numbers
  1. SELECT someFields
  2. FROM someTable
  3. LEFT JOIN mainTable
  4. ON someTable.weapon = mainTable.weapon
  5. WHERE mainTable.weapon IS NULL
Jan 7 '12 #4
Luis Del Valle
3 New Member
I just might be stupid but I dont get it. I hope that you understand that I am a Marine and what im best at is killing the enemy of the United States. Computers, and Microsoft Access im just learning. If you can break it down for me Barney style it would be great.
Jan 7 '12 #5
Rabbit
12,516 Recognized Expert Moderator MVP
Basically, you take that, put in your table names and field names. Then use that as the record source for the combo box.
Jan 8 '12 #6
NeoPa
32,584 Recognized Expert Moderator MVP
This short article on SQL JOINs may help you to understand better what Rabbit is saying.
Jan 9 '12 #7

Sign in to post your reply or Sign up for a free account.

Similar topics

4
2512
by: thomastk | last post by:
Hi, In the following script, I am trying to set selection to a select option element, that is newly created within the script. It works fine on IE installations on Windows 2000 and some XP machines. But on some XP machines, the selection doesn't happen and it defaults to the first element in the options array. Has anybody come across this problem ? Any known workarounds? Thanks Thomas.
1
2769
by: smash2004 | last post by:
I want to keep selected values in select list when i click on another option...with a click on a mouse... if i have 3 options in select list and i click first option..it gets selected..if i then click on third option ..it gets selected but i want also the first option to stay selected when i click on option that is already selected, then it should be deselected
2
8107
by: Monty | last post by:
I use a SELECT dropdown as the nav interface for jumping to a chosen page number. When I setup up the SELECT element on the page, I want to show the user the current page number they are on, so, I put "selected" next to the page number, as shown below: ------------------------------- <form name="pick" method="post" action="showit.php"> <select name="pggo" onChange="this.options.selected;document.pick.submit();">
8
2170
by: Matt Kruse | last post by:
Using the latest version of Opera 8.5, this test case: -------------------------------------------------------- <select name="sel" multiple="true" size="3"> <option value="option1" selected>option1</option> <option value="option2" selected>option2</option> <option value="option3" selected>option3</option> </select> <input type="button"
2
11426
by: ahmad | last post by:
when i used the statment for(var i = 0; i < menu.length; i++) { menu.options.selected = "false"; } to deselect all the options within a list, it surprisingly selected all the options. I tried another option like menu.options.removeAttribute("selected");
3
6443
by: Beholder | last post by:
I hope that someone can help me with the following: Short background explenation: I have a shrfepoint page (newform.aspx) in a item list. On this page is a lookup column that displays a lookup of all category items in previous items. In the code this results in a select/options list like this: <SELECT TABINDEX=1 NAME="urn:schemas-microsoft-com:office:office#CatLookup"><OPTION
0
923
by: sunilrajak | last post by:
i have a combobox in one of datagrid's column.now if i selecting any one value from combobox next time it woll not be in the list of combobox.
1
2429
by: Chezza | last post by:
Hi All, Thanks to those that have helped me before. It’s been a couple of weeks since I posted (I can only play with this during my spare time at work) so here’s the set up again- we receive many “little” shipments of four different versions of something. We combine these into one “big” shipment which we send out to be processed. Currently I have one main form for the big shipments, based off of a “big shipment” table and a...
2
1188
by: princelindie | last post by:
My code is similar to the one below. <html> <head> <script src="selectuser.js"></script> </head> <body><form> Select a User: <select name="users" onchange="showUser(this.value)"> <option value="1">Peter Griffin</option>
1
2288
by: dekk | last post by:
Hi, I have a main form ("frm_TimeParent") and a subform ("frm_TimeChild"). Issue: How do I refresh the combo box values in the subform once the contract has been selected in the main form? Background: The main form has a combo box ("cbo_Contract") which obtain data from a QUERY ( SELECT ., . FROM tbl_Contract; ) and has a control source ("Contract_id).
0
9901
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
9752
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
11031
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
10684
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
1
7918
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
5744
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
5942
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
4563
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
4159
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.