Creating a grid map.

[Database Designs]

I'm not exactly sure where I should go with this but I'll give you my dilemma. I have created a database for a cemetery. The database tracks which section, lot, and grave someone is buried in. My client is looking for a map of the cemetery so thay can click on a particular grave and it would bring up the related record of who is buried. The cemetery is broken up into different sections and they are odd shaped. Any suggestions or examples would be greatly appreciated.

[mr_vodka]

Perhaps it would make more sense to upgrade to 8.5, create a flash application or AJAX front end so that the users can select the location, and finally you can have FM to hold the data.

Comment posted a basic grid example using repeating fields a while back but in your case, it seems as though that using a different front end would probably be a better solution.

[Database Designs]

I am using 8.5. What do you mean by a flash application?

[comment]

I think it depends on how odd-shaped the shapes are, and how many shapes are there in total.

[mr_vodka]

I could have sworn that I read that you had 8 in your profile earlier.

Anyway, watch this webex video to see what I mean by using a Flash interface. You will see examples of a seating chart, maps, etc.

i-Solutions Flash Integration Webex

[Fenton]

I would echo comment's question. If the shapes are irregular, and the placement is also, I don't think any tool is going to be able to "automatically" plot it. You would basically have to draw it (or get a map of it, or go up in a balloon and take photos -). A CAD program would be better than FileMaker for this, because of its measuring tools.

As far as showing who's in a grave, you can have 1 script, with a different parameter for each grave; the parameter being the unique (auto-enter) ID of the grave; which can never change. Tedious, some maintenance required to add new graves/buttons. The buttons could be invisible, or have a slight line for demarkation.