How about a telephone log?

[Polyvox]

This is my first post. Glad to be here. I saw a telephone log on another application on a friend's computer that I thought was very cool. I thought FileMaker should be able to do that. I wonder. The layout appeared as follows: The top half of the screen was a single typical database record, name, address, etc. The bottom half of the screen was a phone log with columns for a date and time stamp, remarks, references and so on. The net effect was that my friend could call up any name in the database and see a record of every phone conversation he had had with that person. It seems to me there must be an elegant solution to this in FileMaker. Any takers?

Thanks in advance.

[T-Square]

A second table (Calls) with fields:

CallID (Auto-enter serial number),

PersonID (linked to Persons::PersonID),

CallDate (Auto-enter Get(CurrentDate)), [or Timestamp]

UserID (Link to Users::UserID), [this is linked to a 3rd table]

Topic (Text)

Add a Table Occurrence PersonCalls in Relationship graph and create a relationship between Persons::PersonID and PersonCalls::PersonID, set to Allow creation in the PersonCalls table. Oh yes--set the relationship to sort by CallDate descending (which will put the last call at the top).

Add a portal on your Persons layout, based on PersonCalls and put PersonCalls::UserID (use valuelist for users based on Users table), and Topic fields in portal. Put the other fields on the portal, but set them as read only in Browse mode. Optionally, add a button to allow deletion of the current portal row. [Note: if you have user login features, you can eliminate the user field and set the field to auto-enter the username based on the login.]

Now you will see all the previous calls to the person, and when you want to add a new call, go to the empty row in the portal, select the User, and add a topic. All the rest should get auto-filled.

HTH,

David

[RT]

Have a look at this file by fenton

http://fmforums.com/forum/showtopic.php?tid/182992/