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

Home Posts Topics Members FAQ

Lookup comboboxes in join-table forms

3 New Member
Hi!

Lookup combos seem not to work in my special case.
I try to demonstrate my problem with these two pictures:

Image 1
Image 2

Does anyone know the standard solution to my problem?

Thanks.
Nov 12 '08 #1
3 907
Frinavale
9,735 Recognized Expert Moderator Expert
I'd recommend that you create 2 data sources instead of sharing them and in the Selected Index Changed events make sure that they correspond with one another.

In the future could you please provide error details about your problem is?
Thanks.

-Frinny
Nov 12 '08 #2
prog123
3 New Member
I have recreated my DataSets so that now I have 3 separate DataSets (Divisions, Employees, DivisionsEmploy ees), and still my problem remains.

The more concrete details of my problem is the following.
I click the "Add New" icon, a new record is created within the memory.
I click the "DivisionsCombo Box", and select one of the divisions listed by name.
After creating the record and selecting a division I cannot set the focus on "EmployeesCombo Box", because the focus stays on "DivisionsCombo Box".
Nov 13 '08 #3
Frinavale
9,735 Recognized Expert Moderator Expert
I have recreated my DataSets so that now I have 3 separate DataSets (Divisions, Employees, DivisionsEmploy ees), and still my problem remains.

The more concrete details of my problem is the following.
I click the "Add New" icon, a new record is created within the memory.
I click the "DivisionsCombo Box", and select one of the divisions listed by name.
After creating the record and selecting a division I cannot set the focus on "EmployeesCombo Box", because the focus stays on "DivisionsCombo Box".
Wow, I thought you were facing a completely different problem....
This is a perfect example of why you need to provide more details in the future.

Anyways, when do you want the focus to change?
After you select a Division?
In that case you should implement this in your SelectedIndexCh anged event.
I'd have to see what you're doing....or you're going to have to explain it in more detail.

What have you tried so far to solve your problem?

-Frinny

(Please remember to use code tags when posting code snippets)
Nov 13 '08 #4

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

Similar topics

1
470
by: gudia | last post by:
David: It is not a join as keys are not present in both the tables; between will just restrict the values for test_val. However, the following solution has been proposed by Joe Celko, which works. Thanks to everybody who contibuted. David and Joe, thanks so much. UPDATE T1 SET factor = (SELECT T2.factor
5
1391
by: Susan Bricker | last post by:
Any idea why a combobox would not populate? When the form is opened, it is opened with DOCMD.OPENFORM with selection criteria to send only those records for a particular dog (dogregnbr). The query for the rowsource of the combobox works when run from the query design window. combobox: cboTrialDt (trial date) combobox control source: trialclassID (from tblDogTitles) form record source: tblDogTitles
1
1310
by: Craig G | last post by:
for months we have been dabling round looking at various 3rd party comboboxes that allow the user to type text into the combobox as a search mechanism what we've found is that the likes of OpinatedGeek comboboxes do seem to work for exacrtly what we want to do but only if you use IE! if i try and run them in netscape navigator it falls over with errors on the load/rendering of the actual control itself so is there any 3rd party...
1
379
by: Marcin Podle¶ny | last post by:
Hi, I've a form with three comboboxes. Each of them contains the same data - all cities in my country. As you see it's a lot of data so it takes a lot of memory. I'd like to use the same datasource for all three comboboxes but property Datasource works in different way than I want. It looks like it copies all data to items of each combobox. So it takes more memory (3 * items + 1 * datasource) and works slowly. Is this possible to use...
2
2617
by: David Pratt | last post by:
Hi. I like working with lists of dictionaries since order is preserved in a list when I want order and the dictionaries make it explicit what I have got inside them. I find this combination very useful for storing constants especially. Generally I find myself either needing to retrieve the values of constants in an iterative way (as in my contrived example below). Perhaps even more frequent is given one value is to look up the matching...
8
7046
by: rh0dium | last post by:
Hi all, I have a dict which looks like this.. dict={'130nm': {'umc': }, '180nm': {'chartered': , 'tsmc': }, '250nm': {'umc': , 'tsmc': } }
1
1122
by: John | last post by:
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
2
1756
by: ashishtarlekar | last post by:
Hi all, I have to add comboboxes in the first row of datagridview for mapping the database fields. For e.g. I have to show Id, FirstName, LastName in each comboboxes in the first row. if i select a database which contains 2 fields then this data should be displayed from second row so that the user can choose the header name for this two columns from comboboxes like Id, FirstName, LastName etc. Can anybody tell me the solution?
2
11447
by: Matt | last post by:
Hi all, me again! :) I've now got an issue with combo boxes. Basically, I have a number of items that I want a user to pick from a single list. It's basically along the lines of: Fruit 1: Fruit 2: Fruit 3:
2
1989
by: Wingot | last post by:
Hey, I have a view to a database that I have created for Client Maintenance. It has a number of fields, but the important ones are Medical Condition, Bill To, and Country. I have a couple of external tables: One for Countries that store each Country as a ID (char(2)), and Name (varchar(50)) pair; One for Medical Conditions, using ID (int) and Name (varchar(50)). Also, the BillTo field refers back to the same table that is being...
0
8837
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...
0
7347
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
4171
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
4329
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
2739
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
1969
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
2
1732
bsmnconsultancy
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...

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.