Jump to content
Sign in to follow this  
pcvdwh

calculated field in self join relationship on parent side fails

Recommended Posts

I am trying to have a user friendly navigation of records within a layout of a table. The user would only need to click in the portal from a self-join relationship to go to the related record (i.e. sessionid).

Now the portal is intended to show a filtered subset of records, according to criteria from a childtable (i.e. only future dates and empty dates in this example). See layout 'test'.

So far I have tried a selfjoin based on a calculated field 'cwaitinglist' having a value 1 in case the criteria are met, and an auto-enter field 'c_one' (also tried a global storage without success). From the forum I learned that the calculated field can be used in a relationship if used on the parent side.

In the example the second portal based on the self-join using the uncalculated field 'manual' shows the intended behavior, however without the automation of the calculation.

As a novice I am probably overlooking somthing obvious. Any input is very much appreciated.

-Philip

test_waitinglist_portal.zip

Share this post


Link to post
Share on other sites

Hi Philip, welcome to FM Forums! :laugh2:

Your sessions table appears to be a 1-to-1 relationship to your Dates table. May I ask why you have them as two distinct tables? Once we can understand the purpose and context, we can probably help you structure your file properly.

Please describe the data entities involved in your design. I see no Patient tables. What types of sessions are you tracking?

LaRetta

Edited by Guest

Share this post


Link to post
Share on other sites

Try to see how I would deal with the matter... if I get it right???

--sd

That is exactly what I was looking for.

Thanks Soren

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×

Important Information

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