Lookup comboboxes in join-table forms

[prog123]

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.

[Frinavale]

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

[prog123]

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".

[Frinavale]

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)