Adding many records to a map to show the status of a piece of land
i was asked whether it is possible to color maps in Filemaker.
The objective would be to show the status of a piece of land with some kind of mark in different colors
It's about a development plan which all pieces of land should be given a color. Eg sold=green, yellow = optional, red = for sale, ....
The data comes from a separate database (2000 records) where for each piece of land a record is created, which then has various information about this piece of land
Annex one example of how it should look like.
The logical solution would be to make 2000 fields in a table a make 2000 relations to a field in the table where all pieces of land are.
But that requires a lot of work !
I hope there is a shorter way ?
Can somebody help me wth this problem?