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

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

×
×
  • Create New...

Important Information

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