Jump to content
Salesforce and other SMB Solutions are coming soon. ×

Call Log database creation - Help!


Recommended Posts

Hi all,


Fairly new to database design here, though I've been an end user of Filemaker for quite some time. I've made a few tweaks on databases before, but I'm trying to design some databases from the ground up, & I've run into a bit of a snag.


The goal here for me is to create a database where I can enter my contacts, by client-- and then have a separate table for "calls" where I can log each individual phone call that is made. So far, so good-- I have a little pop-up list of the clients, on my "Call log" page, so that the pertinent contact info for the client pops up, and I can see their contact info right there on the "call log" page.




I'd like to be able to have a layout in which I can toggle through the clients one by one-- and then see, in "list" view, presumably-- the individual calls that are made (fields include "Date" "Time" "Subject" and then a scrolling box with "Call Notes"). This way, I can call up an individual client and see all of the calls that have been made.


I've tried my hand at these list views, and it doesn't seem to work out. Am I not thinking this through correctly? It would seem this is a pretty straightforward database.


I'd like to have one contact per page, with a flexible list of each of the calls made to that contact, with all the details.


I currently have 2 tables: "Contacts" and "Calls" -- they're related simply through the "Client Name" field.


Any guidance would be helpful-- I've taken some guidebooks out of the library, but there are only so many "sample mileage charts" I can do without learning the solution to my problem!





Link to comment
Share on other sites

It appears that your solution is not far away!


Arrange the CONTACTS details on one page and then make a portal for the CALLS. Depending upon your resolution and screen size you can, your portal can summarize the information (small) or contain multiple fields (from the CALL table) and be quite detailed.

Link to comment
Share on other sites

This thread is quite old. Please start a new thread rather than reviving this one.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

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.

  • Create New...

Important Information

Terms of Use