Event Tracking

[the_kid]

Howdy,

We want to be able to track various events like incomming email, phone calls and fax receipts. I've got two tables; events and contacts. Contacts holds all of our contact information. Events has a "To:" field and a "From" field. Try as I might, I can't get the "From" field to display properly. It wants to show the same information that is in the "To" field. I've attached a little test file as an example. We don't want a look up field as the names in the contact table sometimes change (misspellings and incomplete names are typical). Any shoves in the right direction are greatly appreciated. :P

events.zip

[efen]

Added extra table occurrence and change of "From" field to that occurrence - is this what's required?

see amended file

test1.zip

[Fenton]

This is how I'd do it, using the anchor-buoy graph method; not necessary, but less messy in the long run (though more TOs).

I added portals to see who a contact had mailed to, as well as who they'd received from. Interestingly, you want to see the opposite; if you were the sender, you'd want to see the receiver, and visa versa.

Events_test.fp7.zip

[the_kid]

Fenton and Efen,

Thank you both for your thoughtful responses. I think this is the kick in the pants I needed! Much appreciated.