Relationship between two fields

[pedromaia]

Hello my friends.

I'm new in this FileMaker world and i have a question with wich i think you could help me.

I have a contacts database and i would like to create a command so that one field could be automatically filled accordingly to the information in a first one. Let me try to make it simple to understand...

Imagine i want to write a letter to a car factory. In this layout i have a "name" and an "adress" field. What i want is to look for "Automotive Parts, Inc" in the "name" field and the "adress" field to get automatically the remaining information, let's say "Ferrari Street, F40 Modena Italy". Is this possible? How can i do it?

Thanks in advance for any information you can give on this subject!

PS - I'm sorry for my very poor english, but it's not my mother language... I must practice it, i know...