Related valuelust showing empty lines when "Include "Other..." is used

FMP 6.0.4 / XP

Dear Listeners :

I have a value list filled with values from a related file. No problem so
far.

I wanted the user to enter custom values, too. So I ticked the "Include
"Other"... box in the Filed Format window. Works fine (although it would be
optically nicer to have a separation line just above the Entry "Other..." at
the end of the popped-up value list).

But by doing so an empty line appears between each value in the pop-up menu.

It's of course not a tragedy - but why? And is there a way to avoid that? I
tried to reduce the paragraph line height but that changes only the
appearance in the field *after* a value has been chosen.

---
Met vriendelijke groet / Mit freundlichen Gruessen / With kind regards
Christoph Bouthillier
p/o\s/t atsign ohnotekstotaaloh nocom
Leave out: \ / oh no
---
Christoph Bouthillier [ So, 26 August 2007 15:36 ] [ ID #1805650 ]

Re: Related valuelust showing empty lines when "Include "Other..." is used

>
> I have a value list filled with values from a related file. No problem so
> far.
>
> I wanted the user to enter custom values, too. So I ticked the "Include
> "Other"... box in the Filed Format window. Works fine (although it would
> be optically nicer to have a separation line just above the Entry
> "Other..." at the end of the popped-up value list).
>
> But by doing so an empty line appears between each value in the pop-up
> menu.
>
> It's of course not a tragedy - but why? And is there a way to avoid that?
> I tried to reduce the paragraph line height but that changes only the
> appearance in the field *after* a value has been chosen.
>
> ---

Christoph,

It shouldn't do that, showing empty lines between values. One way to go (and
a way I prefer) is not using the "Include other", but creating a gui where
the user has to go (in this case the related table). Here he/she can manage
the values needed. If you need certain values you may lock it so no records
can be deleted, by creating an extra field (NoDel), then disabling the
delete wit a password etc, then creating a script that checks the new field
and disallows deleting when the field is set. When properly done you have a
far more stable way to manage the connected value-list. Although it does
seem to be much more easy to just allow the "Include" it will give added
control when done through the table. All this is my personal preference :-)

Keep well, Ursus
ursus.kirk [ Mo, 27 August 2007 10:40 ] [ ID #1806134 ]

Re: Related valuelust showing empty lines when "Include "Other..." is used

"Ursus" <ursus.kirk [at] wanadoo.nl> schrieb im Newsbeitrag
news:46d28de1$0$45233$dbd45001 [at] news.wanadoo.nl...
> >
>> I have a value list filled with values from a related file. No problem so
>> far.
>>
>> I wanted the user to enter custom values, too. So I ticked the "Include
>> "Other"... box in the Filed Format window. Works fine (although it would
>> be optically nicer to have a separation line just above the Entry
>> "Other..." at the end of the popped-up value list).
>>
>> But by doing so an empty line appears between each value in the pop-up
>> menu.
>>
>> It's of course not a tragedy - but why? And is there a way to avoid that?
>> I tried to reduce the paragraph line height but that changes only the
>> appearance in the field *after* a value has been chosen.
>>
>> ---
>
> Christoph,
>
> It shouldn't do that, showing empty lines between values. One way to go
> (and a way I prefer) is not using the "Include other", but creating a gui
> where the user has to go (in this case the related table). Here he/she can
> manage the values needed. If you need certain values you may lock it so no
> records can be deleted, by creating an extra field (NoDel), then disabling
> the delete wit a password etc, then creating a script that checks the new
> field and disallows deleting when the field is set. When properly done you
> have a far more stable way to manage the connected value-list. Although it
> does seem to be much more easy to just allow the "Include" it will give
> added control when done through the table. All this is my personal
> preference :-)
>
> Keep well, Ursus


Ursus,

If I understand you correctly you are suggesting to let the user - when he
wants to enter/modify a value in the field in question go to another screen
(?). In my particular case that would be somewhat "off-road". Instead of a
plain pop-up menu field (choosing from a selection of surnames from a
related file, with the "Other.." being other and/or additonal surnames) the
user would be sent astray just for that one field, right?

BUT I FOUND THE CULPRIT!

That particular value-listed field is (for screen space reasons) 2 lines
high to accommodate for long names and/or more than one name. When reduced
to a 1 line height, the problem is gone. I now added a second insible
instance of
the same field but only 1 line high, made the upper/visible one "dead"
and made it a button calling the invisible right next to it.

So although the reason for the behaviour is now found, I'd like to rank it
more as a bug than a feature ;=)

Thanks anyway for your thoughts.

---
Met vriendelijke groet / Mit freundlichen Gruessen / With kind regards
Christoph Bouthillier
p/o\s/t atsign ohnotekstotaaloh nocom
Leave out: \ / oh no
---
Christoph Bouthillier [ Mo, 27 August 2007 20:48 ] [ ID #1806136 ]

Re: Related valuelust showing empty lines when "Include "Other..." is used

"Christoph Bouthillier" <post [at] tekstotaal.com> schrieb im Newsbeitrag
news:dd430$46d31ca1$d4ba06cf$3916 [at] news.speedlinq.nl...
>
> "Ursus" <ursus.kirk [at] wanadoo.nl> schrieb im Newsbeitrag
> news:46d28de1$0$45233$dbd45001 [at] news.wanadoo.nl...
>> >
>>> I have a value list filled with values from a related file. No problem
>>> so
>>> far.
>>>
>>> I wanted the user to enter custom values, too. So I ticked the "Include
>>> "Other"... box in the Filed Format window. Works fine (although it would
>>> be optically nicer to have a separation line just above the Entry
>>> "Other..." at the end of the popped-up value list).
>>>
>>> But by doing so an empty line appears between each value in the pop-up
>>> menu.
>>>
>>> It's of course not a tragedy - but why? And is there a way to avoid
>>> that?
>>> I tried to reduce the paragraph line height but that changes only the
>>> appearance in the field *after* a value has been chosen.
>>>
>>> ---
>>
>> Christoph,
>>
>> It shouldn't do that, showing empty lines between values. One way to go
>> (and a way I prefer) is not using the "Include other", but creating a gui
>> where the user has to go (in this case the related table). Here he/she
>> can
>> manage the values needed. If you need certain values you may lock it so
>> no
>> records can be deleted, by creating an extra field (NoDel), then
>> disabling
>> the delete wit a password etc, then creating a script that checks the new
>> field and disallows deleting when the field is set. When properly done
>> you
>> have a far more stable way to manage the connected value-list. Although
>> it
>> does seem to be much more easy to just allow the "Include" it will give
>> added control when done through the table. All this is my personal
>> preference :-)
>>
>> Keep well, Ursus
>
>
> Ursus,
>
> If I understand you correctly you are suggesting to let the user - when he
> wants to enter/modify a value in the field in question go to another
> screen
> (?). In my particular case that would be somewhat "off-road". Instead of a
> plain pop-up menu field (choosing from a selection of surnames from a
> related file, with the "Other.." being other and/or additonal surnames)
> the
> user would be sent astray just for that one field, right?
>
> BUT I FOUND THE CULPRIT!
>
> That particular value-listed field is (for screen space reasons) 2 lines
> high to accommodate for long names and/or more than one name. When reduced
> to a 1 line height, the problem is gone. I now added a second insible
> instance of
> the same field but only 1 line high, made the upper/visible one "dead"
> and made it a button calling the invisible right next to it.
>
> So although the reason for the behaviour is now found, I'd like to rank it
> more as a bug than a feature ;=)
>
> Thanks anyway for your thoughts.
>
> ---
> Met vriendelijke groet / Mit freundlichen Gruessen / With kind regards
> Christoph Bouthillier
> p/o\s/t atsign ohnotekstotaaloh nocom
> Leave out: \ / oh no
> ---
>

In addition of course the order of placement must be observed - the
invisible field to be opened via a script has to be created first on the
layout, otherwise things still don't get right.
Christoph Bouthillier [ Mo, 27 August 2007 20:59 ] [ ID #1806137 ]

Re: Related valuelust showing empty lines when "Include "Other..." is used

>>
>> That particular value-listed field is (for screen space reasons) 2 lines
>> high to accommodate for long names and/or more than one name. When
>> reduced
>> to a 1 line height, the problem is gone. I now added a second insible
>> instance of
>> the same field but only 1 line high, made the upper/visible one "dead"
>> and made it a button calling the invisible right next to it.
>>
>> So although the reason for the behaviour is now found, I'd like to rank
>> it
>> more as a bug than a feature ;=)
>>
>> Thanks anyway for your thoughts.
>>
>> ---
>> Met vriendelijke groet / Mit freundlichen Gruessen / With kind regards
>> Christoph Bouthillier
>> p/o\s/t atsign ohnotekstotaaloh nocom
>> Leave out: \ / oh no
>> ---
>>
>
> In addition of course the order of placement must be observed - the
> invisible field to be opened via a script has to be created first on the
> layout, otherwise things still don't get right.

Probably you can create it whenever you want and then nudge it down until it
is on a layer below the other field. This is exactly what happens. The field
you create last is always on top.

Keep well, Ursus
ursus.kirk [ Di, 28 August 2007 08:47 ] [ ID #1806942 ]
Datenbanken » comp.databases.filemaker » Related valuelust showing empty lines when "Include "Other..." is used

Vorheriges Thema: automatic field creation
Nächstes Thema: Problem with FileMaker 9 -- "do not evaluate if all referenced fields are empty"