Simple Problem, going crazy!!

[SoCalMacDude]

Trying to create a neighborhood map.

Table 1 is Residents with 6 fields, including Address and Name.

This table will be populated as people arrive at the meeting, and name tags will be printed for each person. Separate record for each person, 2 people per address.

I want to place each address on a map layout of the neighborhood. Then I will print the map for everyone at the end of the meeting.

Tried lots of options, no luck.

I tried using a Houses table, each record is an address. One problem seems to be that a layout is a record, so I get one related record for the entire map. What am I missing? What's the best approach?

How could this best be done?

Edited August 12, 2009 by Guest
Clarification!

[jwjay]

I tried something similar with Zip Codes and different colors representing different levels of sales.

What I ended up doing was using Container fields and Calculations. I had a .png with the background and a .png for each zip code. Since all the picture files were the same size I could overlay the Container fields and the zip codes would show up in the right place on the map.

You could have a "Neighborhood Map" table that only contains 1 record. The fields would be House 1 Address, House 1 Person 1, House 2 Person 2, etc.

You could then create the outline of the map in a layout and overlay container fields on it. When the person(s) arrive, you can manually or have a script paste the names into the corresponding container that goes with their house/address.

[mr_vodka]

I would use a bunch of 1 line portals to display each address record on the map.

[SoCalMacDude]

Thanks, guys! I appreciate the quick response!

I made the map, used the container idea (it came in first), worked great! We had the neighborhood party, awesome name tags & map, and drank lots of Vodka (etc.)!!

FMForums is sooo great when you are under time pressure and get a mental block. Better than banging your head against the wall!