Lets say I have a form called Planet_Systems and a form called
Species. I then want to link the primary key "Planet" to bring up
it's various species in the corresponding subform. So, I created a
subform species within the forum Planet_Systems. They're linked
properly and related etc.. I typed into the Planet combobox: "Earth".
I would now like for all of the different Species found on Earth to be
listed in the subform automatically once I click on a button in the
main form or something. I guess it's sort of a lookup or requery
function but I'm not too sure. Any experienced Acces users know what
I'm trying to do here? 2 5457
In your sci-fi example, there would be a many-to-many relationship between
Planets and Species, i.e.:
- one planet has many speicies, but also:
- one species can appear on many planets.
You need 3 tables to handle this relation:
- tblPlanet, with PlanetID primary key;
- tblSpecies, with SpeciesID primary key;
- tblPlanetSpecie s: one record for each combination, with foreign keys
PlanetID and SpeciesID.
The subform would be bound to tblPlanetSpecie s, with a combo box to select
the species.
For another example and more detail, see: http://allenbrowne.com/casu-06.html
--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
"Alienz" <ks*****@yahoo. com> wrote in message
news:58******** *************** **@posting.goog le.com... Lets say I have a form called Planet_Systems and a form called Species. I then want to link the primary key "Planet" to bring up it's various species in the corresponding subform. So, I created a subform species within the forum Planet_Systems. They're linked properly and related etc.. I typed into the Planet combobox: "Earth". I would now like for all of the different Species found on Earth to be listed in the subform automatically once I click on a button in the main form or something. I guess it's sort of a lookup or requery function but I'm not too sure. Any experienced Acces users know what I'm trying to do here?
Well I would like the subform to actually bring up its 1st entry based
on the primary key in the main form...and then to be able to scroll
through the subform values so its a bit different. Dont know what time
it is in Au. Thanks for your help and if you have any more suggestions
pls reply when you can! The way Im doing it now the subform values are
associated with the main form but I have to create a new entry and then
go back to view the associated subform entries. The subform is not
populated immediately once I enter a value into the main form primary
key. Im trying some things like maybe a call function but its not
working because the subform has several values and I guess I want it to
jump to the 1st.
I explained it a little more here: http://groups.google.ca/groups?q=kst...8&selm=58e54da
4.0405192038.49 aa1d72%40postin g.google.com&rn um=2
But no one could answer that post :(
Btw, is it winter in Australia now.
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it! This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: John Howard |
last post by:
I've sent several messages over the last year asking about python -
Who teaches python? Is python losing steam? etc. I have noticed, eg,
the declinng number of books at my local borders. The last time I
visited a borders (last week), there was 1 (sic) book about python on
the shelve compared to dozens on perl & java! On my last inquiry about
who teaching python, I got two, maybe three, responses. I really want
to see python succeed! It's...
|
by: Bob Bonn |
last post by:
Upon loading a page, I'd like a narrow image to rise up from the
bottom of the screen, along the left-hand side, and then stop at a
given point. I'd like to be able to choose the rate of ascent
(because too fast would look awful, and too slow would be, well, too
slow). After it reaches its destination, it wouldn't move again.
I assumed there would be a javascript for this. However, I've
searched all my favorite sites, but there...
|
by: Robert Oschler |
last post by:
I have an IFrame on my web pages that displays useful tips. I have a button
next to it that hides and shows it by triggering a Javascript call. I know
how to make the iframe invisible by changing it's "visibility" property, and
I know how to change it's size using the style "height" property.
The problem is, with both of those techniques the IFRAME still occupies the
same amount of real estate as before, even if it's now invisible /...
|
by: JohnEGee |
last post by:
Hello, all, and TIA for any help you can offer. I've searched the
Internet for answers and have finally come here.
I've created a page (several, actually) with a link that opens a pop-up
window. It's a pop-up window in the sense that it's smaller than the
man page and is intended to be viewed and then closed.
The problem is that if I include a link on that pop-up window HTML
page, when the link is clicked the new page opens IN the...
|
by: Travis |
last post by:
I am trying to prevent an exception from bubbling up from one nested
Try/Catch Block to its "Parent" Try/Catch Block. Here is some example
code:
try{
try{
//Non-application killing code that causes the exception
}
catch(Exception ex){
//Exception is caught and logged here
| |
by: Lars Netzel |
last post by:
I'm pushing out a CD with updates for a number of users that do not have
access to a broadband connection. They have a Modem connection and a
standard Dial Up account that I have set up for all of them. Now we have
changed the ISP to get it cheaper and I need to change the telephone number
in all those dial up connections created on the computer.
How can I access and change the telephonenumber from my application that
comes with the CD...
|
by: AA Arens |
last post by:
I made a find record button on my form "company" (with field for name,
phone nr, e-mail etc.).
I expect that when I focus on one of the field, the "look in" of the
find-record dialog box should be set to the field, but instead of that
it is set to the form name (company). To avoid it I have to set it
manually to the focussed field. How to have it default set to the
focussed field as I used to find records containing cetrtain data in
the...
|
by: AA Arens |
last post by:
I use the undermentioned code to find a record in a predefined "Look
In" field:
Private Sub Command137_Click()
On Error GoTo Err_Find_Record_Click
Me.CompanyName.SetFocus
DoCmd.DoMenuItem acFormBar, acEditMenu, 10, , acMenuVer70
Exit_Find_Record_Click:
Exit Sub
Err_Find_Record_Click:
|
by: puzzled |
last post by:
I have "Find" buttons throughout my database, each with focus on a different field (they were created with the wizard, then the focus set to the corresponding field with VB). If i press a find button and change the "Look In" combo to search the form instead of a field, the next "find" button i press defaults to 'Look In' the form, not the field that should have focus. The field that should have focus is available to select in the "Look In" combo...
|
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: 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...
|
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...
|
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: 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...
| |