November 15, 200421 yr Is it possible, using datafilter, to get (in my example) all of the treatment dates per name per given period in a seperate file? In my file "Invoeren Datums", you can find all of the given treatments as seperate records. This file is linked to another file "Patienten". The meaning of my question is to create invoices for one with a summary of all their treatments within a given period. I 'll enclose hereby the files. Thanks for helping me out of this... InvoerenDatums.zip
November 15, 200421 yr You need to upload both files - please do! If patients confidentiallity are at stake here make some dummies!! --sd
November 15, 200421 yr Author Hi - Thanks for that quick reply and mentioning that i forgot to upload the related file. Still hope someone can help me. Hereby the forgotten file. 1100522997-Patiënten.fp5.zip
November 15, 200421 yr Author Hi Lee, thanks for your reply. My trials to upload the files doens't seem to work quite well... With this reply, I'll send now an archive of the three requested files. Thanks for some help... Yves Files.zip
November 15, 200421 yr Right, you need either to make a calc'field in both files Month(theDate) and relate these two fields to each other if you only invoice clients on a monthly basis. If some clients should have shorter or longer credit must a multilinekey be made from the fromDate and toDate fields, that makes all the dates in between either by a hashing algorithm like Edoshins Smartranges or simply by a calcfield ...this will make the relation key to Sum( over. --sd
Create an account or sign in to comment