Hello, I am a complete newbie to FileMaker and I need help creating an application. I would like to create two databases.
The first one would contain a log of communications containing date/time, contact's name, company, and notes from the communication. I would like the information in a form and a table so I can sort by company, most recent, etc.
The second would be similar to an address book. It would contain a contact list. Then in the form view it would contain detailed contact information, company information, as well as a small table (on the form) that would contain a list of the most recent communications with that contact's company from the other database.
I would like to keep this as one application however since it deals with two different types of records (conversation log & contact) I don think that is possible. So that means it will need to be two different applications, which is alright but I don't have the first clue how to have them talk like that. Any help would be appreciated. If someone could even help me lay out a template that I could further edit and modify I would really appreciate it. Thank You.
