I have a database consisting of 3 tables, the main table with main
contact info, a second table with additional address info and a third
table consisting of additional contact information, or more
specifically 'other names sometimes used to identify the main contact
person'.
I have related the tables, the main contact info table being the main
table on the one side, and the other two tables hold additonal data
and are on the many side.
The tables are related properly. In the main table a number data field
called "List Identifier" distinguishes each contact and is the primary
Key, the tables on the many side relate to this field through a Number
Data Field called "Link to List Identifier." I have built a form with
a subform attached.
The form I've built displays the info correctly however there is one
caveat; for each "Contact name" field in the main or one table there
may be from 1-10 corresponding "other names used" information in the
many table that correspond to the one contact's name in the one table.
[More specifically in the many side table I might have "other name
used 1", "other names used 2", etc in the many table. Say for this
example "other names used 1" and "other names used 2" in the many
each correspond to the contacts name, "John Smith" in the one table.
John Smith's List Identifier is say "10021" in the main table. Each
"other name used" entry in the many table uses the "10021" linking
number in the "Link to List Identifier" field to relate it correctly
to John Smith].
My form displays the first corresponding "other names used"
information in the appropriate field, correctly from the many table.
My question is, how do I display on the form the other, anywhere from
1-10 "other names used" info from the linked table on the many side?
Can anyone assist me with this. Thank you. 1 1806
You could try changing the subform view to Continuous. This would
display as many names as would fit into the space you allocated to the subform.
Pavel
Johnfcf wrote: I have a database consisting of 3 tables, the main table with main contact info, a second table with additional address info and a third table consisting of additional contact information, or more specifically 'other names sometimes used to identify the main contact person'.
I have related the tables, the main contact info table being the main table on the one side, and the other two tables hold additonal data and are on the many side.
The tables are related properly. In the main table a number data field called "List Identifier" distinguishes each contact and is the primary Key, the tables on the many side relate to this field through a Number Data Field called "Link to List Identifier." I have built a form with a subform attached.
The form I've built displays the info correctly however there is one caveat; for each "Contact name" field in the main or one table there may be from 1-10 corresponding "other names used" information in the many table that correspond to the one contact's name in the one table.
[More specifically in the many side table I might have "other name used 1", "other names used 2", etc in the many table. Say for this example "other names used 1" and "other names used 2" in the many each correspond to the contacts name, "John Smith" in the one table. John Smith's List Identifier is say "10021" in the main table. Each "other name used" entry in the many table uses the "10021" linking number in the "Link to List Identifier" field to relate it correctly to John Smith].
My form displays the first corresponding "other names used" information in the appropriate field, correctly from the many table. My question is, how do I display on the form the other, anywhere from 1-10 "other names used" info from the linked table on the many side? Can anyone assist me with this. Thank you. This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: Hamed |
last post by:
Hello
I have employed as a developer in a software company that its team uses
FoxPro / VB 6.0 / VC++ 6.0 as the developing tools and newly is going to
migrate to VS.NET. There is a project modified that is to upgrade a big,
more than 100,000 lines DOS based program developed by FoxPro 2.x to .NET
platform. The design is as previous and...
|
by: Kevin Myers |
last post by:
Hello,
Please forgive my reposting of this note with hopefully a more relevant
subject line.
On an Access 2000 form under Windows 2000 I would like to use a Kodak Image
Edit Control to display the contents of a TIFF image file. According to the
very limited documentation that I have been able to locate so far, all I
should need to do is...
|
by: Robert |
last post by:
Hello Accessors
I have some reports created in Access that are very good for what they do.
However, it seems to me that when you are displaying information you don't
need to print out that a printer-friendly report is not the best way to go.
So, I tried converting one of my Access reports to an Access form. I
selected the continuous view...
|
by: Bob Alston |
last post by:
Most of my Access database implementations have been fairly small in
terms of data volume and number of concurrent users. So far I haven't
had performance issues to worry about. <knock on wood>
But I am curious about what techniques those of you who have done higher
volume access implementations use to ensure high performance of the...
|
by: Bob Alston |
last post by:
Some more, rather specific Access performance questions. IN a split
front-end & back-end Access/Jet ONLY LAN situation, and with all query
criteria fields and join fields indexed:
1. Is is good form to have a single query with base table with criteria
joined to a related table - all in one query? Or should I do a
two-step, first query...
| |
by: Fendi Baba |
last post by:
I am new to access development, please bear with me if these questions
sound trivial.
I am creating an Access application using link tables. My database
resides in MSDE. I have created multiples tables such as schools,
teachers, etc in MSDE.
1. This is my first question: In order to show user friendly data, I
have created a form...
|
by: Cheryl Langdon |
last post by:
Hello everyone,
This is my first attempt at getting help in this manner. Please
forgive me if this is an inappropriate request.
I suddenly find myself in urgent need of instruction on how to
communicate with a MySQL database table on a web server, from inside
of my company's Access-VBA application. I know VBA pretty well but
have never...
|
by: ApexData |
last post by:
I am considering building some distributable commercial applications.
For about a year now, I have been using Access2000. This was my first
venture into object oriented database development. Having a
background in Pascal and some C++, I would have preferred those
languages, but VBA made do. The SQL was fine.
I believe that Security...
|
by: Sid |
last post by:
I hope someone could help me with this.
I am trying to setup a criteria to decide when to allow/not allow
user
to click on the check box. logically it looks simple but I am not
able
to incorporate in my data access page. I have a numerical field
called
tier status and right next to it I have a checkbox. I would like to
allow user to...
|
by: prakashwadhwani |
last post by:
Hi !! I'm about to develop a new project for a client.
Should I go about it in Access 2003 or 2007 ? Purchasing it either
for me or for my client is not a major consideration here ... what I'd
like to know is the stability, speed & ease of use of both the
products.
I believe Access 2007 has a new file format too and that it may be...
|
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. ...
| |
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...
|
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...
|
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...
|
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...
|
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...
|
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...
| |
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...
| |