Finding Records through relations

[justdippin]

Hello all,

I have a problem with my DB and relationships and finding the records.

I have added the file with this post:

accountname: admin

there is no password.

I have a 1 to many relationship.

Groups, think of this as a mothergroup of all companies.

Company, the company.

In my layout I want that the user selects a group and than selects a Company related to the group chosen. Since it's a 1 to many relationship many companies can be shown in the dropdown menu after selecting a group.

See: search (chose group first) This layout works.

But it must also be possible to select (or type) a Company and that the group is automaticly shown. Since it's a 1 to many relationship the group is known, if a specific company is chosen. (see mailfunctioning lay-out: search chose whatever u want)

The idea is that both options are available in one layout and both can be done.

If it has to be done in 2 layout that's not a real big problem, but i rather have it in one.

I hope anyone can help me out with this problem,

Thx

test.zip