Damn, I just typed up a whole post and the bloody forum then lost it :(
Anyway, here I go again :(
Looks like you need a simple list view with a sub summary part sorted by Personnel ID.
I'm assuming your one table contains:
- A personnel ID to relate a training record to a personnel member.
- An expiry date
- Some way to "check" the record if it has been completed.
If this is the case you could use a calculation field to see if the record is expired or not. Something like:
If "record is not checked and Expiry date is older then today" = "Out of Date"
Then you can perform a find for all "Out of Date" records, sort by personnel ID and you have a list of all Out of date records sorted by Personnel member.
If you need any more help let me know!
(And I hope the forum doesn't loose this post again) :(
Hi Guy Stevens,
The forum has recently manifested a bug where it logs you out at random intervals. If you have opened a thread to add a comment and then this random log out occurs, your comment disappears when you try to post it.
Right Now and FileMaker Inc. are aware of the issue and the Right Now programmers are supposed to be treating this as a high priority bug to fix, but so far, no fix has been forthcoming.
Until a fix is released, I strongly recommend copying a comment to the clipboard just before posting it. That way, you can sign in, click back to the page where you originally tried to post the answer and there you can paste and re-submit. It's easy to forget and God help those filling out an issue report, but it's best I can offer you at the moment.
Will try to remember :)
Thanks for your suggestion I'm going to give it a go. Is a quick find a useful method for searching across multiple fields? I had an idea trying to go to sleep the other night. If I had a calculation field in the table with a text result that alogorithmically added a line of text for each field that had an expiry date IF expiry date < get (currentdate). I could then set up a layout in list mode categorised or sorted (I don't know the difference) on ID or Name , perform a find for the text calcuation field if it does not equal "" and hopefully it will give me a format similar to my example.
That's indeed what you would be doing. But you don't need a quick find for this. There would essentially be one field that contains a value like "Expired"
You just perform a find in that field. The character you can use to perform your find is "*"
That will find you any record with a value in that field.
If you need any more help, let me know.