Multiple lookups - one to many???

[keysol]

Hi,

I'd like to have two fields where I would, in the first field select from a lookup the name of a company.
Once I select a company the second field would display within a lookup the names of the people with that comapny only.

The lookup data would be in a separate file or files (not sure about this).

Can anyone point me in the right direction on this.

Thanks.

Gerr

 

[rshboston]

Not sure if I'm understanding your situation properly, but it sounds like a relation would do the trick. Let's say you have two files (companies and people). Create a relation between the two using an appropriate field (company code for example).

Next, in the company file, create a layout that contains a portal using the previously defined relation. You can place fields from the employee file (first name, last name, etc.) in the portal. Each company record will now show just the employees that belong to that company.

This is a more dynamic solution than using lookups. Hope it is appropriate to your needs. If so, let me know if you need more help implementing it.

 

[keysol]

Hi rshboston,

Thanks for your response

Maybe I can be clearer if I explain the purpose.
I'm trying to create a layout for a fax cover page. When I click in the "Company Name" field I would like to be able to choose from a list of companies or, if necessary simply type in a company name that is not yet in the list.
Then I would tab over to the "Name" field where I would select a name from a list of names associated with that company or again if need be, I would simply type in a name if the company name was not part of the company list.
I would allow for the updating of the lists with an Update Files Button.

I hope I managed to be clearer.

thanks,

Gerr