I have a layout containing a portal with two rows. By the nature of the database, the table for the layout has at most two related records.
For one field of the related table, only one value is shown, the value
in the first row. Other fields display properly, a value in each row.
Any ideas? Anything I should check that I either left out or didn't
think to do?
Charlie
On 2018-07-14 22:07:21 +0000, Charles H. Sampson said:
I have a layout containing a portal with two rows. By the nature of the database, the table for the layout has at most two related records.
For one field of the related table, only one value is shown, the value
in the first row. Other fields display properly, a value in each row.
Any ideas? Anything I should check that I either left out or didn't
think to do?
Assuming the values are meant to be different, then the two most likely explanations are either that the Field is not within the first row's
borders in Layout mode, or that the Field is not using the same
relationship as the Portal.
Helpful Harry :o)
Helpful Harry <HelpfulHarry@BusyWorking.com> wrote:
On 2018-07-14 22:07:21 +0000, Charles H. Sampson said:
I have a layout containing a portal with two rows. By the nature of the
database, the table for the layout has at most two related records.
For one field of the related table, only one value is shown, the value
in the first row. Other fields display properly, a value in each row.
Any ideas? Anything I should check that I either left out or didn't
think to do?
Assuming the values are meant to be different, then the two most likely
explanations are either that the Field is not within the first row's
borders in Layout mode, or that the Field is not using the same
relationship as the Portal.
Helpful Harry :o)
I'm not quite sure what you mean by "the values are meant to be
different", Harry. Certainly, the values are coming from two different records in the related table, which can be verified by the fact that
other fields in the portal are showing distinguishing values. The values
from the two related records are the same, but that's true for values
from another field and they display properly.
I'm also confused by "the field is not within the first row's borders in layout mode". My problem is that I don't know what you mean by "the
first row's borders". In any case, here's what the Inspector tells me:
The top of the portal is at 2.292" and the right side is at 7.514". (The misfiring field is at the right of the portal.) All of the fields in the portal have a top of 2.292". That right-most field has a right side at
7.5".
As to your third point, the portal is showing records from the related
table. The field is showing values from a field in that related table.
Here's a new bit of info. I've been tinkering around with some of these dimensions, making the portal larger, the field smaller, etc. When I do,
the borders of the field in the first row are clearly visible, with
white space around them. However, in the second row, this area is
completely blank. In other words, not only is the value of the field
missing, the entire field seems to be missing.
I have a layout containing a portal with two rows. By the nature of the database, the table for the layout has at most two related records.
For one field of the related table, only one value is shown, the value
in the first row. Other fields display properly, a value in each row.
Any ideas? Anything I should check that I either left out or didn't
think to do?
Charlie
On 2018-07-14 22:07:21 +0000, Charles H. Sampson said:
I have a layout containing a portal with two rows. By the nature of the
database, the table for the layout has at most two related records.
For one field of the related table, only one value is shown, the value
in the first row. Other fields display properly, a value in each row.
Any ideas? Anything I should check that I either left out or didn't
think to do?
I have a layout containing a portal with two rows. By the nature of the database, the table for the layout has at most two related records.
For one field of the related table, only one value is shown, the value
in the first row. Other fields display properly, a value in each row.
Any ideas? Anything I should check that I either left out or didn't
think to do?
Charles H. Sampson <csampson@inetworld.net> wrote:
I have a layout containing a portal with two rows. By the nature of the
database, the table for the layout has at most two related records.
For one field of the related table, only one value is shown, the value
in the first row. Other fields display properly, a value in each row.
Any ideas? Anything I should check that I either left out or didn't
think to do?
Sorry to be late in following up on this, but I went on vacation and
just got back to checking USENET, after catching up with tons of mail
and email.
It turns out that everybody was right (no surprise). The misfiring field
was slightly out of the portal. Once I fixed that, all is well.
I "discovered' this by shrinking the size of the field's font, then
shrinking the size to the field itself. It was then easy to make sure
that the field lay within the portal and everything worked fine. The interesting effect was that when I enlarged to field back to its
original size, it stayed within the portal. Enlarging the font back to
its original size and all now works as I wanted it to.
As always, thanks to all who helped.
Sysop: | Keyop |
---|---|
Location: | Huddersfield, West Yorkshire, UK |
Users: | 296 |
Nodes: | 16 (2 / 14) |
Uptime: | 78:48:25 |
Calls: | 6,658 |
Calls today: | 4 |
Files: | 12,203 |
Messages: | 5,333,076 |
Posted today: | 1 |