[Hx] Concatenating records

[ROGER BILLCLIFFE rogerbil@mac.com]

I’m making catalogue entries for works of art and have produced a listing report for my collection that pulls together known information about an object from its ID number across various relations – history, exhibitions, references etc

Here is a typical result in the report, showing instances that an object was included in a specific exhibition:

  

This shows the number of times an item has been included in an exhibition; I can get similar results tracing its history or publication references. Each line refers to a separate record in a relation.

I would like to concatenate these individual records, joining them with a semi-colon like this:

 Memorial Exhibition, 1933 (162); Edinburgh, 1968 (8, pl.3); Glasgow Art Gallery, 1978 (13)…..

and so on, so that the report can be used in a word processing program or web design program without excessive editing. I know how to concatenate individual fields within a relation, but can it be done across different records?

Thanks in advance

Roger

[Lenny Eiger eiger@databright.com]

Roger,

Posting can solve this, either to the relation you are in (with option 0), or to another relation.

You look up the value (or if on the same record put the value in a display tile) and default an inert field on the form you will use to post. Then you append the new value to that inert field, and post the result of that into a field.

Does that help?

Lenny

> On Sep 20, 2023, at 7:34 AM, ROGER BILLCLIFFE roge...@mac.com <Hel...@gibhenry.com> wrote:
>
> I’m making catalogue entries for works of art and have produced a listing report for my collection that pulls together known information about an object from its ID number across various relations – history, exhibitions, references etc
>
> Here is a typical result in the report, showing instances that an object was included in a specific exhibition:

> <Screenshot 2023-09-20 at 15.18.36.png>

>
> This shows the number of times an item has been included in an exhibition; I can get similar results tracing its history or publication references. Each line refers to a separate record in a relation.
>
> I would like to concatenate these individual records, joining them with a semi-colon like this:
>
> Memorial Exhibition, 1933 (162); Edinburgh, 1968 (8, pl.3); Glasgow Art Gallery, 1978 (13)…..
>
> and so on, so that the report can be used in a word processing program or web design program without excessive editing. I know how to concatenate individual fields within a relation, but can it be done across different records?
>
> Thanks in advance
>
> Roger
>
>

=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

You received this message because you are subscribed to the mailing list <Hel...@gibhenry.com>.
To unsubscribe, send an email <Helix...@gibhenry.com>; to switch to DIGEST mode, send an email to <Helix-L...@gibhenry.com>; to contact a human being, send an email to <Helix-L...@gibhenry.com>.
Google archive since 20 August 2006: http://groups.google.com/group/helix-l.
Basic archive since March 2017: https://gibhenry.com:9100/Lists/Helix-L/List.html