Bonjour,

I defined a company table (with address information) and another table
for contacts in a company (we can have more contacts in a same company),
I linked the two tables with a uniq company id.
Then, I defined another new table, called Hot Line Calls, linked on the
company table also with the company id.
Hot Lines calls are open by company contacts (second table), in my Hot
Line Layout I would like to select in a contact list when the company id
has been entered (retype the contact name is boiring)
I tried with look up value, but I could only get the first define
company contact and I need a menu list with all the contact for the
selected company ...
So my question is, with FileMaker Pro 7, can I define menu list from the
result of the look up data option ? if yes I would be glad to hear that ...

Thanks for your help
Tof