It's probably best to not try to do this on the portal. You should get you found set, go to the layout the found set is based on and do a Replace Field Contents.
And I would guess that your script would need to create a number of new related records to populate with this note. A loop could take one record of this table and duplicate it, updating the match field to related it to different houses in the development.
But another option would be to change your relationship design so that instead of making duplicate copies of a note, you simply link that one note to all applicable records in your table so that it becomes visible from the context of any one of those records.
Thank you both for your responses. I have tried to do this via the "Notes" layout instead of the portal. Right now it seems like I can duplicate the first note in that layout, but I cannot seem to get it to show up in the portal for the other address.
I really like the idea of linking the records-but I am not sure how to do that. Since it is a database of houses, it would be nice to link all the houses within one development. Can you point me in the direction of how to do that?
Here is a link to a simplified version of my database. I pre-apologize because I'm sure some of my relationships are crazy or I may have skipped some steps. You should be able to use the guest account.
When you duplicate the record, you then have to update the match field in the newly created record in order for it to link to a record for a different house.
If you want a note to apply to all houses in a development, perhaps you need an additional notes table that links to a table of development records.
DevelopmentNotes>----Developments-----<Houses-----<HouseNotes (----< means "one to many" )