I have built a data base containing a series of documents, approximately 1000. I have also built a tracking file who keeps track of who has read the publication and when. There is 1000 potential readers. All of this on the web. So far I have managed to do so and it works well. When someone reads a document, he clicks on a button which enters the reader's ID, the documet ID and the date and time on a second file. Now I need to produce a web list of which member of the potential readers list who has NOT read the document. This has to be done using FMP 6 unlimited. It would be easy to do so unsing FMP 8 but... Is there a way to set a relationship in FMP6 which used in a protal would list who has not read a document? If I could do that then I could list it on a HTML file.

Thanks for your help...

Notr

Edited September 24, 200520 yr by Guest

I think you will need a multi-key field which is modified via script. If you have a value list of all potential reader IDs, you can set a field with it and then loop through and remove all IDs which exist in records related to the document ID. Then a portal based on a relationship from this field to the reader ID field would display all potential readers who have yet to read the document.

I do not think I can elaborate much more without first seeing your structure.

Thank you for your suggeston. I have decided to use the TEXT plugin from Troi. It does the job perfectly.

Thanks again