Nigel Strudwick

And I thought about how to achieve it on my walk this afternoon and it is now fixed. Thank you so much for that simple tip! Stay well!

Yes that did occur to me! Just got to adjust the way I think about it. Thanks again.

Thank you. I was thinking it had to be some limit of which I was unaware, and I really appreciate your suggestion of a summary field with a running total, which I hadn't thought of, although I have used them before. My only problem with that sometimes I need to add and sometimes to subtract, but I will see what I can do. I downloaded the trial version of FMP19 and it worked better in that, but in Filemaker Go 19 it was still giving the ? above. All suggestions are very gratefully received.

I'm having an issue with the getnthrecord function. I am using it in conjunction with the get(recordnumber) function to get a value from field X in the previous record in a sorted list (i.e. getnthrecord (X ; get(recordnumber) -1), and then add or subtract something from it to give the value of field X in the current record. It's working fine for the first 130 records in the found set (out of about 150) but thereafter it shows a ? in the field--and I cannot click that field to see what value is in there, so it's not obviously a wrong formula or a larger number than the size of the field can contain. I've tried it in various databases/tables and it always seems to happen at about the same record in the found set, regardless of the size of the data. Can anyone shed any light on why this is happening please, or have another way I can do the same thing? The attachment shows sample data sorted on a time field, and at the left, the getnthrecord is used to add 10 to the value of the same field in the previous record. Thanks in advance...

Thank you both for your answers. I think I have it figured out. "List" is what I was looking for--I'd missed that function completely, but it seems to do what I wanted, by allowing me to process the related records as one string. I'm trying to produce a complex presence-absence chart of persons vs certain titles, and I believe I have the key now. Thank you again!

Greetings. I have two linked databases, one of persons and another of their titles, linked on an ID field; it's a one-to-many relationship. I need to be able to calculate whether each selected person has a variety of titles, which means checking through each element of the set of related records and setting a flag for that person. Years ago I did this in Algol with this sort of pseudo-code: For each person For each related record If the title is one of the ones needed, set a flag in the person DBF End loop of related records End loop of persons What I can't figure out is how I make the if test on just the records related to the person. I am probably approaching it from the wrong way in FMP... I hope this is clear. Thanks!

Thanks very much. That does sound rather daunting, so it looks as if editing is the best solution. Not being able to export HTML tags seems a rather fundamental oversight in FMP does it not? Cheers...

I suspect this has been asked many times before... I've got a number of URLs in my databases, which I want to be active in an exported HTML file--I've added href tags to some of them. Now when they get exported, all the critical HTML characters (e.g. < & >) are expanded out into HTML entities (rather like they do on this forum). This of course means they're not read as HTML tags by a browser, but as literal characters. Is there a way of stopping this conversion which seems to happen as an inevitable part of the export process, or am I forever condemned to editing them back before I use the HTML as a web page? Thanks!