You'll need a 2nd table with one field for each country. (You only need have one record in this table.) Then define relationships from each of these fields in this table to the same country field in the table you now have.
Put the appropriate country name in each field in your new table.
You can now create portals for each of these relationships and put them where you want them on your map layout.
I'm sorry, I'm missing a step somewhere.
I made a second table with 4 fields named London, Madrid, NY & Venice then dragged a relationship from each field to the City field of my original database. I then made a layout based from the second table and created portals to the original table.
but it doesn't show any information. What am i missing?
What values did you put in your fields? The relationships will match the field contents not their names. So if you've left them empty, you don't have any matching records. You can put the city names in your fields manually or define them as calculations that return text.
Define Your London field as a calculation: "London" (literal text enclosed in quotation marks) with "text" selected as the return type.
Here's an example of the data going in:
Spain, Madrid, Juan, 07989834076
Spain, Madrid, Julia, 02084638264
Italy, Venice, Sam, 02083647382
England, London, Crispy, 02074527364
USA, New York, Peggy, 5558394
I think my problem lies within the relationship. Currently, all i have done is create the 2nd table with the 4 cities in and matched it to the city field in the above table. But even if i make it a calculation, it doesn't show any data in the portal.
Thank you for bearing with me
What data do you have in your second table?
You need a single record with fields that contain your city names.
If you select the layout that FMP created when you defined this new table and selecte "table view", what do you see?
I see 4 fields labeled London, Madrid, New York & Venice.
Then there is one record in that table that has a repeat of the field name so in table view, underneath the London field heading is "London", underneath Madrid is "Madrid" etc etc
... so those who are in the London office only appear in the field/portal that i place over london.
How can you place a portal ( or even a single field ) over a city of a whole world map picture ?
I would use tool tips instead.
To Raybaudi: When I was Editor In Chief of Inside Filemaker Pro many years ago. I once asked people to send in samples of creative Filemaker Pro layouts. Even back in those days with a much less capable version, the submissions were truly amazing. Thus, I don't assume that using a World Map as the background isn't workable :smileywink:
I think I see your problem. When you created your relationships linking your new 1 record table, did you do something like this....
- Let's call your original table "Main" and your new table "Cities".
- Using your mouse, create a relationship linking Cities.London to Main.City by dragging from one field to the other.
- Select the Main Table.
- Click the button at the bottom that looks like two over lapping "+" signs.
- You now have a new table reference for Main labeled Main 2. It looks like you've created a new table, but it's just a different reference to your Main table so that you can define a different relationship between Cities and Main.
- Now drag from Cities.Madrid to Main 2.City to create a relationship between these two "Table references.
- Repeat for each city field in "Cities".
- Return to your Map layout which should have Cities as it's underlying reference table.
- Define a portal for Main, Main 2, Main 3.... Main should now list all your London records, Main 2 will list your Madrid records and so on....
I realize that this can be confusing for the new user. I was picturing it backwards myself until I set up a little test file to make sure my directions were accurate.