Portal and Relationship Misery.

Posted on 2006-06-06
Medium Priority
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

billmercer earned 1200 total points
ID: 16853645
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

Author Comment

ID: 16902443
Works for me!

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Pop up windows can be a useful feature of any Filemaker database.  Though best used sparingly, they can be employed in a multitude of different ways, for example;  as a splash screen at login, during scripted processes to control user input, as pick…
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…
In a question here at Experts Exchange (https://www.experts-exchange.com/questions/29062564/Adobe-acrobat-reader-DC.html), a member asked how to create a signature in Adobe Acrobat Reader DC (the free Reader product, not the paid, full Acrobat produ…
Screencast - Getting to Know the Pipeline
Suggested Courses
Course of the Month14 days, 5 hours left to enroll

807 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