HELP! Time Clock Mapping!

[all-out]

Ok, so i have a time clock working great, i have the ip address connected to stations in the building so you can tell what station the employee clocked in at. Now i have map of all the stations and i want to display who clocked in where on the map.

Ive am thinking portals, with some relationships will do the trick.

What do u guys think?

Thanks

[Colin Keefe]

If you're talking about a spatial representation map - a graphic of your floor plan with portals or related fields scattered about over it - then yes, what you're suggesting is what I'd probably explore first. A couple of points:

1. It's not scalable - new workstation locations will require new map relationships.

2. You'll probably want to set up a utility table with IPaddress/locationID pairs, because you'll want to use the LocationID for your relationships. If you use IP addresses in your relationships they'll break as soon as the network topography changes.

3. As soon as your office moves, the map breaks.

That said, there are some very clever people on this list who will likely suggest a better method.

[Fenton]

You do know that you can specify which row(s) of a portal shows? So you could have only 1 portal, umpteen times on the layout, each one showing only 1 row, 1st one starting at 1, then starting at 2, then 3, etc.. Then there's only 1 relationship, likely a self-constant.

I don't know if this helps, but it's something to be aware of.

[all-out]

Ok, so i made some progress today. i created a self relationship with the table that has the data of what station they clock in at.

I have a portal displaying the station that want to see by using a find command, however, now my problem is creating multiple portals on the same layout showing different station results like name, time in, time out..

Thanks agian