Jump to content


  • Content Count

  • Joined

  • Last visited

Community Reputation

0 Neutral

About gfr92y

  • Rank

Profile Information

  • Title
    Sales Rep
  • Industry

Recent Profile Visitors

The recent visitors block is disabled and is not being shown to other users.

  1. I apologize for introducing unnecessary confusion in my last post. (Once I am finished answering your questions, I will go back and revise/delete heavily.) A customer can have any number of sales reps assigned to it; No, a customer can only have one sales rep assigned to it. A sales rep is assigned to only one customer; No, a sales rep is assigned to either 10, 11, or 12 customers. A sales rep can make any number of calls; Yes, a sales rep may call a customer as many times as they like. A call is made by one sales rep only. Yes. It is rare that two sales reps would participate in a cal
  2. I have 116 customers each with its own sales rep and 11 sales reps each with 10-12 customers and are responsible to "call" (i.e., visit, call, or email) each customer 4-5 times per month. How does Max ( CallReport::CallDate ) know to calculate the maximum value of each Customers' CallDates individually and then populate the LAST CALL DATE field with the maximum value by customer? Sorry if I did not make this intent clear originally.
  3. CUSTOMERS - A table of customers where each CustomerIdNumber is an auto serial number SALESREPS - A table of sales reps such that: Each SalesRep-to-Customer relationship is one-to-one Each ContactIdNumber is the concatenation of the CustomerIdNumber, a hyphen, and the auto serial number generated when the sales rep was entered into the SALESREPS table CALLREPORTS - A table of call reports such that: Each CallReport-to-SalesRep relationship is one-to-one Each CallReportIdNumber is the concatenation of the ContactIdNumber, a hyphen, and the auto serial number generated when the call report
  4. I feel like I should know how to do this, but I keep going around in circles. (I have tried to demonstrate what I am trying to do below.) Simply put, I want to populate the field Last Call Date with the date of the last sales call, i.e., Call Date, for each company. (I think I am OK on the sorting afterwards.) Two more things... I need the values in the Last Call Date field to remain unchanged when the data is not sorted, and I can update the Last Call Date when needed. However, it would be nice if it updated itself anytime a more recent Call Date was entered. I would appreciate any assi
  5. Lee, Thanks. Comment, OMG! I am speechless. Great! Terrific! Thank you! Well, almost speechless.
  6. Comment, I am not familiar with the three icons circled below. Could you please tell me what they signify and how you caused them to be visible? Thanks!
  7. WOW! I can't wait to dissect it and learn your secrets! Thanks! I will let you know how it goes. Joe
  8. I have a portal that I will call LIST OF CUSTOMERS. (Photos #1 & 2) My desire is to type the first few letters of a company's name in the global field CallReport::ChooseCustomer and click on a red square button (Photo #4) to populate the portal LIST OF CUSTOMERS with an alpha-sort of my customers' names starting with Customer2::CustomerName >= CallReport::ChooseCustomer at the top and ending with Zywux on the bottom. Everything works PERFECT except the portal does not refresh such that Customer2::CustomerName >= CallReport::ChooseCustomer is listed in the first row of the portal no
  9. When I Searched for 'refresh' in Topics, I Found 2,448 results. When I Searched for 'portals' in Topics, I Found 7,185 results. When I Searched for 'portals refresh' in Topics, I Found 9,505 results. Clearly the third search is "portals" U "refresh" in Topics. How do I perform the search "portals" ∩ "refresh" in Topics? More specifically, how do I perform the search "portals" ∩ "refresh" in the sub-forum FileMaker 13 General Discussion only? Thanks!
  10. ​I had wondered if I should mention why I was asking the question and before making a thoughtful decision, I was off thinking about something else. Why... Before my relationship graph looked as neat and orderly as it does, it was a web of duplicate table occurrences. One had 4 the other two had five plus there were some related and unrelated table occurrences present as well. Knowing that most of the table occurrences were not serving any useful purpose, I went layout-by-layout and view-by-view to determine which table occurrences had field in each layout and view. After identifying those tha
  11. LaRetta, comment, and Fitch, A big thank you very much to each of you for sharing your knowledge and insight! My plan forward is to try each of your suggestions regardless of any duplication of effort hoping to be the benefactor of any serendipitous knowledge I might stumble across. Sincerely, Joe
  12. ​Fitch, Thanks for the concern! I am glad to say the relationship graph is constructed from three tables: CUSTOMERS, CONTACTS and CALLREPORTS. However, I do not think I have anything close to an optimal database design. I also know I tried to implement some functionality that is not functioning as I want it to and I am sure it is directly related to my lack of experience and know-how. That said, I do not want to impose on or burden others. Thanks, again! Joe
  13. ​Thank you for raising that point! If I understood you correctly and considering I know the specific table occurrence whose records are shown on each of the 24 layouts, I think my question should have been: Without having to go layout-to-layout, is it possible to easily identify which layouts each table occurrence had fields in? Thanks, again!
  • Create New...

Important Information

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