473,657 Members | 2,392 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Drop down lookup problem

Hi

I have a client table with clients and their ids. Some client names are
duplicate as they have several locations but ids are unique, so for example;

ID Company
23 MyCompany Inc
27 MyCompany Inc
56 MyCompany Inc

On the orders form I have the clients drop which displays all the clients
for user to select. The problem is; as company names are duplicate selecting
by company name is not enough. How can I select a company but also get the
client id behind the scene? Ideally I do not want to store the id in the
client field bound to the drop down as the rest of the app expects client
name in that field and not client id.

Thanks

Regards
Aug 30 '06 #1
1 1122
Personally, I would use cascading comboboxes to do this, and have a
relationship between company and employee in my database and requery
the comboboxes. There's an example of this at Accessweb.

Aug 30 '06 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

7
3436
by: jorntk | last post by:
How can i make a drop down menu that are dynamiclly generated base on the value selected in another drop down menu? thanks nad regards Jorn
2
12251
by: Zack | last post by:
Hi, I am an access newbie and wanted to get a design check to see if I have done the right thing or if there is a better way. I don't like the Yes/No field option in a table. I want to have the actual Yes or No data in a text box. To accomplish this, I created a new table with one field. There are just two records in the table, Yes and No. I build a Drop Down box control on a form, linked it to this new table, and everything works...
3
1548
by: phil | last post by:
We are developing specs. for a website for a nonprofit org, with database for membership related functions. But..question is regarding drop down menu links. We will have 20 category-pages, and each page will have 30-50 links- unique to that page, so 1000+ total for site- on a drop down menu. Need we assume that such links (both plain english description to appear on site, and actual URL to link to- so 2 pieces data really for each...
2
2457
by: tpaulson | last post by:
I have a couple of DIV's that I hide/display based on radio buttons. On the DIV's, I have multiple drop down boxes. The source shows that they are populated, but I can't make them drop down. Only click on the Unplatted Radio button, the rest isn't functional, yet. Any ideas how to make these drop down in FF. This works in IE. Here is the code: <HTML> <HEAD> <TITLE>Door County Register of Deeds - Tract Inquiry</TITLE>
2
1306
by: brino | last post by:
hi all ! i have a drop down list of names on a form. the problem i have is that the users of this are typing in there own text instead of choosing from the drop down list of names. how can i lock this list so that they can only choose from the list and not type what ever they want to ?? any help would be great as this is causing major problems with some reports !!
17
1792
by: KMEscherich | last post by:
Microsoft Access '97 Using VBA code Have been asked to include a drop-down list which will retrieve the options from lookup table 1, then according to what the end-user selects from this drop-down, I need it to go to lookup table 2 with those specific options and record both selections in a table. Right now, I have a table for each option and corresponding catetory in order to ensure there are no mistakes for each category they want. But,...
4
38598
by: jack.vier | last post by:
I have a table that I am manipulating as a table, not as a form. Is it possible to have a drop down list in a table? I came across this: http://groups.google.com/group/comp.databases.ms-access/browse_thread/thread/509fbf44455ab35d/2e0bced904cccbfa?lnk=gst&q=Drop+down+list+table&rnum=4&hl=en#2e0bced904cccbfa The person answering the question seems to imply that a form should be used if a drop down list is needed. Am I correct in thinking...
5
6066
by: kcddoorman | last post by:
I have a main order table that gets some of its information from several look up tables. A create a look up relationship between the two tables and that allows me to choose a record. I can create another form that allow me edit the individual lookup tables so I can enter new clients, job, employees, etc. I'd like to add a some functionality to the drop down boxes. Can you have a "New" record in the drop down box that lets you enter data? The...
1
2013
by: Basket61 | last post by:
I need to use a drop down box based on table Color that, once you click on a value, populates the field in my form In the main database design, I reference the Table Color, both the ID and the description. For the description field, I ran the lookup wizard, refering to the Table Color, Selecting just the Color field (not the ID). The display control is a combo box (default by access), with row/source type of Table/Query, and row source ...
0
8411
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
8323
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
8838
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
8739
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
8513
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
7351
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
0
5638
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
4173
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...
1
2740
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

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.