List ( Field 1 ; Field 2 ; Field 3 ; Field 4 ; Field 5 )
Edit: from the List function reference:
Returns a concatenated list of non-blank values (separated by carriage returns) for a field or fields."
have you tried the List function? e.g. List ( table::field1, table::field2, table::field3, etc)
Thanks so much. That did the trick.
One more question.
If I then want to create a List field to CONCATENATE List ( table::field1, table::field2, table::field3, etc), how do I ensure there is a carriage break between the results?
Substitute ( List ("a", "b") ; "¶"; "¶¶" )
Use: List ( Field1; Field2 ; Field3 ; " " ; Field4 ; Field5 )
I got the email with your question about ensuring a carriage return. There, it looked like you wanted double-spacing between the values. Is that what you wanted? (The double-spacing didn't translate to the post; or the email added an extra carriage return.)
This might be clearer.
I have a table BIBLIOGRAPHY, and related table PROJECTS, connected through a join table.
In BIBLIOGRAPHY I have a field Citation that is List (Field 1; Field 2; Field 3; Field 4)
In the PROJECTS table I have a field References that is List(BIBLIOGRAPHY:Citation).
I need to make sure that there is a space between each of the Citation clusters in the References result, so:
Field 1 (record 1)
Field 2 (record 1)
Field 3 (record 1)
Field 4 (record 1)
Field 1 (record 2)
Field 2 (record 2)
Field 3 (record 2)
Field 4 (record 2)
what Phil said:
List ( List(field1; field2); " "; List(table::field) )
Im puzzled by that. What do the " " marks between Field3 and Field4 do?
Sorry - I tend to be a bit too brief.
It's an invisible placeholder. It could be anything, like "------".
My question is "why is there a placeholder between Field3 and Field4?"
I believe that Phil was just providing an example of how to create what looks like a blank line within your list. Requirement one was "no blank lines if the fields are empty." List does that. So, you can trick List into providing a blank line by putting a space in as a parameter. (Similarly, if any of your fields look empty, but actually contain a space, a blank line will show in your list.)
Off-topic director, but I used to label my field or variable concatenations "cat". My co-workers thought it had something to do with felines.
OK... thanks so much. One more question on this matter.
If Field 1 is always a year, is there a way to have the List(field) in the PROJECTS table automatically sort according to date? I tried to sort the records in the BIBLIOGRAPHY table by that field, but it does not have any effect on the ultimate List.