Stay updated on everything FileMaker in real-time on the FMT Network! Ask FileMaker Questions and Get Answers on the Original FileMaker Forum online 20 years with 45,000+ Worldwide Members.
Posted In: FileMaker Pro Versions 5 & 6
I am having a problem. I have two databases that are related to each other. One holds requests for tech support the other holds the solutions for those requests. The solutions are viewed in the request database as a portal. It is sorted by SolutionDate. I would like the latest date to be dropped into a field in the request database as part of finalizing the record. I have tried a calculation which ensures the recordID of the request record matches the recordID of the solutions, determine the max date of the solutiondate field. Nothing happens. What can I do?
Is the solution date field defined as a Date field?
Try this in your Request database:
Create a calculation field (result = date) such as this: MostRecentSolutionDate = Max(solution::date)
Where solution in the above is the relationship between the two databases based upon the request number; and date is the solution date field.
I actually tried this. The problem is, the second database, the one that holds the solutions, is related to the record ID number from the work order database. If I did the solution you have suggested, I get the max date in the ENTIRE solutions database, not the max date of only the records related to the work order number.
Do you have another solution?
You must be logged in to reply to this topic.