Hello, I have a database for ordering in my lab. I am trying to link a group of person to a Lab Head.

i.e.

I have a field Group which contain values AA, BB CC etc... name of the lab head

I have a field Person which contain all name of the collaborators (pop-up menu with value list)

What I need is to have in the field Person, only the name of the collaborators of head AA or BB or CC...

I created new field, Person_AA, Person_BB ...but cannot make it done, I tried with relationship stuff but it never works.

I am a newbie in FM programation !

Thanks all

Phil

Philippe,

I'm not sure I understand everything here, but I think what you need is a file called "LabGroups.fp5" or something like that. It should have all the people's names in it (a good place to store contact info!), and a field for the LabGroupHead.

Then, go back to your main database and build a relation:

the left-hand key for the relationship should be Orders:Group

(the Group field in your main Orders database);

the right hand key should be Groups:LabGroupHead

Now, you should be able to define a Value List using only values from this relationship, showing all the Names from the LabGroups file.

Feel free to ask further.

-ESpringer

ESpringer,

Thank you very much for the info. It worked perfectly and now I have another database for the ppl in the labs.

Philippe