Relationship Defined Menu

[Shanksta]

Hi -

I have 2 fields in a form, company and contact person, that are linked to another file for handling our contacts.

If I pick a company, I would like only its employees to appear in contact person, and if I pick a contact person, I want their company to be automatically filled in.

How do I do this?

 

[lebisol]

-look up fields
-portals
-calcualted look up

> need more info?
:: don't click HERE ::

 

[Shanksta]

Any more info you can give me?

 

[Shanksta]

never mind - got it

i am completely blind...

 

[lebisol]

oooook but I think this needs to go the other way arround 1st!
U MUST have more than 2 fileds on this whole project?
what info do u want to see at "the end of it all"?
just the --> [comany][contact person]

ok...if u select a company and want the list of all the emplyees to appear then u can not have this list show in just a field....it needs to be either a portal or a value list

if u select the contact person than this will be easy since this person will work for only 1 comapany. righ?

is this what u had in mind?what other info are u collecting.....

> need more info?
:: don't click HERE ::

 

[lebisol]

heyyyyyy great!
I guess u just needed a little break from it all
All the best!


> need more info?
:: don't click HERE ::