Antofill city from Cap

[bonzer1]

Hello i have a csv file with Cap, city and state.

How can i Autofill city and state in filemaker when i create new record and i insert Cap? It's possible?

 

Thanks

[Kris M]

Import the csv into a table of its own.

Use a calculated field, lookup field, script or relationship to access or move the from the states/cities/capitals table to whatever table you want.

Vague questions tend to get vague answers.

Highly recommend getting the filemaker training series and working through every lesson.

It will teach you the basics of importing, constructing tables, working with calculations, lookups, relationships, and scripts.

[comment]

How can i Autofill city and state in filemaker when i create new record and i insert Cap?

What is "Cap"? And what does a record in your table represent?

In any case, there are basically two options - read the explanation here:
http://www.filemaker.com/help/14/fmp/en/html/relational.12.2.html#1027577