Portal and Relationship Misery.

Posted on 2006-06-06
Last Modified: 2010-04-27
I have 2 database containining Company Employee Records and another one which holds all the information for our Documents (this is the big one)

In the document Database there are two tabels.
The first one contains all the document information such as number and what employees have been assigned to it (full employee checklist from the other database)

The second one is related through the document number and contains all the revision history records (so there are anywhere from 1 - 15+ records per document with revision level A,B,C and so on.  (Remember that one?)

On the other side, I have the employee records related with the assignments in the first database which is then related to the revisions right?  So I've created a portal that will pull up all the revisions for documents that this person is assigned to listing the document number, levels, and date of revisions.  The idea of this was to create a training list but obvisouly I cant change the date in the portal record.

This would be something that I would like to be automatic somehow so if theres an employee with a start date that comes before the document revision date, then display the revision date.  But if they start after, obviously they wern't trainied before they were hired so I would want it to display the hire date.  

I'm at the end of this one!  I'm so close, but its always the final parts that I get stuck at.  Hopefully this can be done, or I'm screwed.
Question by:Cruizectrl
    LVL 19

    Accepted Solution

    Have you considered using a calculated field? If I understand you correctly, something like this should give you what you want.]

    Define an unstored calculated field with this definition

    if ( Employees::StartDate < Documents::RevisionDate;  // If the employee started before the revision date
         Documents::RevisionDate;  // This is the THEN part of the IF, returns the revision date
         Employees::StartDate        // This is the ELSE part of the IF, returns the employee start date
    LVL 1

    Author Comment

    Works for me!

    Featured Post

    Maximize Your Threat Intelligence Reporting

    Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

    Join & Write a Comment

    Suggested Solutions

    Conversion Steps for merging and consolidating separate Filemaker files The following is a step-by-step guide for the process of consolidating two or more FileMaker files (version 7 and later) into a single file with multiple tables. Sometimes th…
    Having just upgraded from Filemaker 11 to Filemaker 12 over the weekend, we thought we would add some tips for others making the same move.  In general, our installation went without incident. Please note that this is not a replacement for Chapter 5…
    It is a freely distributed piece of software for such tasks as photo retouching, image composition and image authoring. It works on many operating systems, in many languages.
    Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

    734 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    21 Experts available now in Live!

    Get 1:1 Help Now