Hi,
Problem:
How do I create a form that contains a pull down list for the source
and destination (reference the table definition shown below) that shows
the name of the item not the id number? The way I am doing it is
through a query which only allows one name field. So I thought to do
it through the pull down list, but it only displays the id. The pull
down list will display both but upon selection just the id is
displayed. I need the name to be displayed?
The following tabl is used:
Relationship Id - Key
Source Id - links to x table
Definitive Item Id - links to y table
Destination Id - links to x table
x Table:
id
name
Anyone have any suggestions on how to do this.
1  1496 
If I understand you right, you're trying to show two columns in a combo
box control, and you've got a SQL statement populating the row source.
If that's the case, you'll need to set the Column Count property in the
control's Format tab to 2, and establish the Column Widths
appropriately based on the width of the columns. If your underlying ID
column is the first in your query, for example, the your Bound Column
property in the Data tab should also be set to 1.
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: Steven T. Hatton |
last post by:
Is there anything that gives a good description of how source code is
converted into a translation unit, then object code, and then linked. I'm
particularly interested in understanding why putting normal functions in
header files results in multiple definition errors even when include guards
are used.
--
STH
Hatton's Law: "There is only One inviolable Law"
KDevelop: http://www.kdevelop.org SuSE: http://www.suse.com
Mozilla:...
|
by: diskoduro |
last post by:
Hi!!
Years ago I built a database to control the production of a little
factory.
The users wanted to work in a Windows Net workgroup so I created an
mdb with all the tables and data an after that every user had his own
mde linked to the main mdb.
Year by year, progressively the number of records has been growing and
the speed of the application has decreased strongly, because of the
grrrreat number of records stored.
|
by: Mark P |
last post by:
I have a bit of vb code that uses Tables.Append to programatically
link tables from Oracle and DB2 datasources. The problem I am having
on some client machines is that the link will take anywhere from 1 to
3 minutes to link the table. When I manually link the tables,through
Access, it takes no time at all. Note that only certain client have
the problem, and the problem will sometimes go away.
These clients will usually get an ODBC Call...
|
by: Matthew Wells |
last post by:
Good morning...
I have an Access front end that uses SQL Server linked tables. SQL Server
uses Windows authentication. I have one Windows group that all Access users
are a member of. I added that group to SQL Server logins and gave it
public, datareader, and datawriter rights to the one database that's used.
My front end is locked down, but I want to stop users from creating a new
..mdb and linking SQL Server tables through DSNs or...
|
by: TheTamdino |
last post by:
One of the things that is common between most genealogy databases is
that they will have one screen were you log all the information for a
given person and then (maybe) have a link to a source record.
I'm trying to create a database where you have tables that record facts
and then link those facts to a person record. For example, I'll have
tables for Birth, Marriage, Military Service, Tax Records, etc. They
are separate tables because...
| | |
by: dskillingstad |
last post by:
I've been struggling with this problem for some time and have tried
multiple solutions with no luck.
Let me start with, I'm a novice at Access and I'm not looking for
someones help to design my database,just help in getting me pointed in
the right direction.
I have a database with 8 tables, which from what I have read, cannot be
linked on a single form, and be updatable. I have created a query
which includes all 8 tables, and then...
|
by: davegb |
last post by:
I've searched here and in the help screens, but I can't find the answer
to a very simple question. How do I create a specific link between 2
records in 2 different tables? I know how to use the Relationship view
to tell Access that a given field is generically linked to another
field in another table. But I can't find a clue as to how to tell it
that Record x in table A is related to Record y in Table B. It seems so
basic, but I can't...
|
by: hmiller |
last post by:
I'm sorry to populate the server with yet another question about
linking multiple tables and queries, howerver I have not been able to
find the right criteria.
My problem.
I am trying to either link 3 tables together in a select query, and
maintain the editablity that I get when linking two tables and creating
a form. I know there is a way to link 3 tables through multiple queries
however I have yet to be able to get it to work.
|
by: guidopapinino |
last post by:
What I want to do is have 2 pull down lists, for example a state pull
down list and a city pull down list. What I would like to have done is
when you select a state from the state pull down list then the city
pull down list will populate with all the cities from that selected
state. I know that is a lot of data but that is just an example. Or
something like when you are looking up cars online they have a make
pull down list and a model...
|
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...
|
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,...
| | |
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...
|
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,...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
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...
|
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();...
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| | |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |
