Jump to content
Sign in to follow this  
gerrys

Finding records that do not match a normal relationship

Recommended Posts

I have developed a training database which includes tables for employees, courses available, course runnings and courses attended etc. It is a easy to see which courses an employee has attended and which employees have attended a particular course. A key requirement however is to be able to run reports to see which employees have not attended a course especially those courses that are mandatory. I have tried setting up relationships based on the comparative operators but cannot get these to work. I am sure it is me doing something silly but any advice on how I might achieve this would be greatly appreciated.

Share this post


Link to post
Share on other sites

Without seeing your structure. I would start with suggesting a separate calculated field that determines if your given set of conditions has been met. Try to have this calculation be stored/indexed if possible (ie it does not refer to globals, unstoreds, or related fields). You can then use this field for your conditional relationship.

EDIT: You used the word "report". Why not just script a find and then go to your report layout?

Edited by Guest

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

×
×
  • Create New...

Important Information

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