Difficult to explain this clearly I'm afriad.
We have several fields (up to six) in our data records that may need to be accessed if a single record is selected. These are free-text fields and may be quite long (hundreds of characters) or they may be blank. I'd like to have it appear a bit like an Access form. So if the data looks something like this (although there are a lot more fields I'm not including here)...
| Date | Time | ID | ...lots more columns... | Comment 1 | Comment 2 | Comment 3 | Comment 4 | Comment 5 | Comment 6 |
|---|
| 1/2/17 | 08:34 | 170130a | | This is the first comment on this event | This event has another comment that is longer than the first one, it is however the last comment for this event. | | | | |
| 1/2/17 | 10:48 | 170201b | | Nil | | | | | |
| 2/2/17 | 06:12 | 170202a | | This event has several longer comments | This one is short | But this one is longer and still should be displayed fully without having to scroll the window | This event even had more comments that were entered in this field | This is the last comment for this event. | |
| 2/2/17 | 13:52 | 170202b | | | | | | | |
| 2/2/17 | 21:27 | 170202c | | Only the one comment here | | | | | |
What we'd like to be able to do is select an ID, or group of (very few) IDs in another table and have displayed something like (in a separate sheet object):
| Header 1 | Header 2 |
|---|
| ID | Comment 1 (if exists) |
| Comment 2 (if exists) This event has another comment that is longer than the first one, it is however the last comment for this event. |
| Comment 3 (if exists) This is the first comment on this event |
| Comment 4 (if exists) |
| Comment 5 (if exists) |
| Comment 6 (if exists) |
| ID | Comment 1 (if exists) |
| Comment 2 (if exists) |
| ... | ... |
I'd just like to know if anyone has any ideas on how to accomplish this lower table (or similar) elegantly?
Thank you!
