Jump to content
Sign in to follow this  
the_kid

Event Tracking

Recommended Posts

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

Share this post


Link to post
Share on other sites

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

see amended file

test1.zip

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

Fenton and Efen,

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

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×

Important Information

By using this site, you agree to our Terms of Use.