Lookup

Hi

I have a list of values that need to be used for one field, a kind of
validation.

I do not want to put them in a 'popup menu' format ideally because
there are 96 values.

Does anyone have any other good ideas of how I can lookup these
values, I will also need an other option for users own entries.

Thanx

Re: Lookup

On Nov 15, 1:56 am, JayBee wrote:
> Hi
>
> I have a list of values that need to be used for one field, a kind of
> validation.
>
> I do not want to put them in a 'popup menu' format ideally because
> there are 96 values.
>
> Does anyone have any other good ideas of how I can lookup these
> values, I will also need an other option for users own entries.
>
> Thanx

Make a 'picker layout'. A layout based on say, a Global table that's
related to a Value List table containing records for each value in the
list. Script the field so that when a user clicks on the field she is
taken to that layout, required to select a value (or cancel) and taken
back to the original layout putting the value in the field.

Re: Lookup

Hi

Thanx

Can that be done in Filemaker Pro 7.0.

Jenny

Grip wrote:
> On Nov 15, 1:56 am, JayBee wrote:
> > Hi
> >
> > I have a list of values that need to be used for one field, a kind of
> > validation.
> >
> > I do not want to put them in a 'popup menu' format ideally because
> > there are 96 values.
> >
> > Does anyone have any other good ideas of how I can lookup these
> > values, I will also need an other option for users own entries.
> >
> > Thanx
>
> Make a 'picker layout'. A layout based on say, a Global table that's
> related to a Value List table containing records for each value in the
> list. Script the field so that when a user clicks on the field she is
> taken to that layout, required to select a value (or cancel) and taken
> back to the original layout putting the value in the field.

Re: Lookup

In article
,
JayBee wrote:

> Hi
>
> I have a list of values that need to be used for one field, a kind of
> validation.
>
> I do not want to put them in a 'popup menu' format ideally because
> there are 96 values.
>
> Does anyone have any other good ideas of how I can lookup these
> values, I will also need an other option for users own entries.
>
> Thanx

You can define a value list to use values from a field. There are
several variants of this.

One way is to use the existing values in the same field.

Another way is to take values from a different field, which can be in a
different and even unrelated table.

When defining a value list to take values from a field, you can select
two fields to use, for example a key field and a text field that
identifies the significance of the key field. You can also define it to
show all values in the reference table, or only those that satisfy a
relationship.

Lots of possibilities.

In the FileMaker Help file, look up <>

Re: Lookup

On 15 Nov, 18:21, Bill wrote:
> In article
> ,
>
> JayBee wrote:
> > Hi
>
> > I have a list of values that need to be used for one field, a kind of
> > validation.
>
> > I do not want to put them in a 'popup menu' format ideally because
> > there are 96 values.
>
> > Does anyone have any other good ideas of how I can lookup these
> > values, I will also need an other option for users own entries.
>
> > Thanx
>
> You can define a value list to use values from a field. There are
> several variants of this.
>
> One way is to use the existing values in the same field.
>
> Another way is to take values from a different field, which can be in a
> different and even unrelated table.
>
> When defining a value list to take values from a field, you can select
> two fields to use, for example a key field and a text field that
> identifies the significance of the key field. You can also define it to
> show all values in the reference table, or only those that satisfy a
> relationship.
>
> Lots of possibilities.
>
> In the FileMaker Help file, look up <>


Hi

Thanks but I still get the impression that the whole list would pop up
at once. Is there any way that Filemaker would recognize the
characters as you type and only pop up with the matching criteria?

Thanks
Jenny

Re: Lookup

>>
>> You can define a value list to use values from a field. There are
>> several variants of this.
>>
>> One way is to use the existing values in the same field.
>>
>> Another way is to take values from a different field, which can be in a
>> different and even unrelated table.
>>
>> When defining a value list to take values from a field, you can select
>> two fields to use, for example a key field and a text field that
>> identifies the significance of the key field. You can also define it to
>> show all values in the reference table, or only those that satisfy a
>> relationship.
>>
>> Lots of possibilities.
>>
>> In the FileMaker Help file, look up <>
>
>
> Hi
>
> Thanks but I still get the impression that the whole list would pop up
> at once. Is there any way that Filemaker would recognize the
> characters as you type and only pop up with the matching criteria?
>
> Thanks
> Jenny
>
>

Jenny,

What you are describing does exist, but it is not as intuitive as I would
like. It works with a calculated field that will contain every combination
of beginning letters. Lets say you have a field that contains the words: My
house. You have to create a calculation that returns
M
My
My h
My ho
My hou
My hous
My house
h
ho
hou
hous
house

Say it will work to up to the first 10 words, that would leave the
calculation manageable (just) and give enough room to search.

Then create a relation betwee n new global and this calculation. When the
user types a letter in this global and tabs out of the global. So when you
type an m all related fields starting withj an m will appear in a portal.
This is best set up in a separate layout, containing just the global and the
portal. With the portal-fields locked. So actualy the global is the only
thing the user can go to AND when you tab out it will directly go back into
the field, because there is nowhere else to go to. A drawback is the
continuous tabbing since the relation to the portal will only refresh after
the contents is committed.

You could also create a relation that connects to all records that contain
the values you need. Then create a portal large enough to see all the
values. You can create the portal in several columns so space would not be a
prblem. The create a button on the first row of the portal that will set the
field you want to the value the user has clicked and return to your main
layout. I would choose this last option in your case.

Keep well, Ursus

Re: Lookup

In article
<12ce937c-b1ed-4a39-9ca6-7868b6b0f2dc@b15g2000hsa.googlegroups.com>,
JayBee wrote:

> On 15 Nov, 18:21, Bill wrote:
> > In article
> > ,
> >
> > JayBee wrote:
> > > Hi
> >
> > > I have a list of values that need to be used for one field, a kind of
> > > validation.
> >
> > > I do not want to put them in a 'popup menu' format ideally because
> > > there are 96 values.
> >
> > > Does anyone have any other good ideas of how I can lookup these
> > > values, I will also need an other option for users own entries.
> >
> > > Thanx
> >
> > You can define a value list to use values from a field. There are
> > several variants of this.
> >
> > One way is to use the existing values in the same field.
> >
> > Another way is to take values from a different field, which can be in a
> > different and even unrelated table.
> >
> > When defining a value list to take values from a field, you can select
> > two fields to use, for example a key field and a text field that
> > identifies the significance of the key field. You can also define it to
> > show all values in the reference table, or only those that satisfy a
> > relationship.
> >
> > Lots of possibilities.
> >
> > In the FileMaker Help file, look up <>
>
>
> Hi
>
> Thanks but I still get the impression that the whole list would pop up
> at once. Is there any way that Filemaker would recognize the
> characters as you type and only pop up with the matching criteria?
>
> Thanks
> Jenny

In recent versions of FileMaker (I think it goes at least back to 7,
don't remember if it goes earlier) you can set up a field in a layout to
auto-complete using previously entered values. That may be what you are
looking for.

In the Layout mode, double-click on the field, and check the box
"Auto-complete using previously entered values"

Re: Lookup

In article
<12ce937c-b1ed-4a39-9ca6-7868b6b0f2dc@b15g2000hsa.googlegroups.com>,
JayBee wrote:

> On 15 Nov, 18:21, Bill wrote:
> > In article
> > ,
> >
> > JayBee wrote:
> > > Hi
> >
> > > I have a list of values that need to be used for one field, a kind of
> > > validation.
> >
> > > I do not want to put them in a 'popup menu' format ideally because
> > > there are 96 values.
> >
> > > Does anyone have any other good ideas of how I can lookup these
> > > values, I will also need an other option for users own entries.
> >
> > > Thanx
> >
> > You can define a value list to use values from a field. There are
> > several variants of this.
> >
> > One way is to use the existing values in the same field.
> >
> > Another way is to take values from a different field, which can be in a
> > different and even unrelated table.
> >
> > When defining a value list to take values from a field, you can select
> > two fields to use, for example a key field and a text field that
> > identifies the significance of the key field. You can also define it to
> > show all values in the reference table, or only those that satisfy a
> > relationship.
> >
> > Lots of possibilities.
> >
> > In the FileMaker Help file, look up <>
>
>
> Hi
>
> Thanks but I still get the impression that the whole list would pop up
> at once. Is there any way that Filemaker would recognize the
> characters as you type and only pop up with the matching criteria?
>
> Thanks
> Jenny

If you can split the data into sub-categories, then you could use two
pop-up menus - the first one narrows down what is displayed in the
second.

For example, choosing "Cartoon Characters" from a Type field would then
cause the Character field to only show character names of that type.
Choosing "SciFi Characters" from the Type field would only display
those types in the Character field.
eg.
Type field Character field
Cartoon Characters Atom Ant
Fred Flintstone
Papa Smurf
Scooby Doo


SciFi Characters Darth Vader
Dr Who
Sculley
Starbuck



Helpful Harry
Hopefully helping harassed humans happily handle handiwork hardships ;o)

Re: Lookup

On 16 Nov, 09:45, "Ursus" wrote:
> >> You can define a value list to use values from a field. There are
> >> several variants of this.
>
> >> One way is to use the existing values in the same field.
>
> >> Another way is to take values from a different field, which can be in a
> >> different and even unrelated table.
>
> >> When defining a value list to take values from a field, you can select
> >> two fields to use, for example a key field and a text field that
> >> identifies the significance of the key field. You can also define it to
> >> show all values in the reference table, or only those that satisfy a
> >> relationship.
>
> >> Lots of possibilities.
>
> >> In the FileMaker Help file, look up <>
>
> > Hi
>
> > Thanks but I still get the impression that the whole list would pop up
> > at once. Is there any way that Filemaker would recognize the
> > characters as you type and only pop up with the matching criteria?
>
> > Thanks
> > Jenny
>
> Jenny,
>
> What you are describing does exist, but it is not as intuitive as I would
> like. It works with a calculated field that will contain every combination
> of beginning letters. Lets say you have a field that contains the words: My
> house. You have to create a calculation that returns
> M
> My
> My h
> My ho
> My hou
> My hous
> My house
> h
> ho
> hou
> hous
> house
>
> Say it will work to up to the first 10 words, that would leave the
> calculation manageable (just) and give enough room to search.
>
> Then create a relation betwee n new global and this calculation. When the
> user types a letter in this global and tabs out of the global. So when you
> type an m all related fields starting withj an m will appear in a portal.
> This is best set up in a separate layout, containing just the global and the
> portal. With the portal-fields locked. So actualy the global is the only
> thing the user can go to AND when you tab out it will directly go back into
> the field, because there is nowhere else to go to. A drawback is the
> continuous tabbing since the relation to the portal will only refresh after
> the contents is committed.
>
> You could also create a relation that connects to all records that contain
> the values you need. Then create a portal large enough to see all the
> values. You can create the portal in several columns so space would not be a
> prblem. The create a button on the first row of the portal that will set the
> field you want to the value the user has clicked and return to your main
> layout. I would choose this last option in your case.
>
> Keep well, Ursus- Hide quoted text -
>
> - Show quoted text -

Hi

I would like to try it. If I have 96 values does that mean I will
have one calculation for each of the 96 values in the list? Or will I
have several calculations for each value to return every possibility?

Thanks
Jenny

Re: Lookup

Send you an answer & example on your private account

Ursus

"JayBee" schreef in bericht
news:b448e87a-1e05-4b10-bd4e-ec73ba043fa2@b36g2000hsa.google groups.com...
> On 16 Nov, 09:45, "Ursus" wrote:
>> >> You can define a value list to use values from a field. There are
>> >> several variants of this.
>>
>> >> One way is to use the existing values in the same field.
>>
>> >> Another way is to take values from a different field, which can be in
>> >> a
>> >> different and even unrelated table.
>>
>> >> When defining a value list to take values from a field, you can select
>> >> two fields to use, for example a key field and a text field that
>> >> identifies the significance of the key field. You can also define it
>> >> to
>> >> show all values in the reference table, or only those that satisfy a
>> >> relationship.
>>
>> >> Lots of possibilities.
>>
>> >> In the FileMaker Help file, look up <>
>>
>> > Hi
>>
>> > Thanks but I still get the impression that the whole list would pop up
>> > at once. Is there any way that Filemaker would recognize the
>> > characters as you type and only pop up with the matching criteria?
>>
>> > Thanks
>> > Jenny
>>
>> Jenny,
>>
>> What you are describing does exist, but it is not as intuitive as I would
>> like. It works with a calculated field that will contain every
>> combination
>> of beginning letters. Lets say you have a field that contains the words:
>> My
>> house. You have to create a calculation that returns
>> M
>> My
>> My h
>> My ho
>> My hou
>> My hous
>> My house
>> h
>> ho
>> hou
>> hous
>> house
>>
>> Say it will work to up to the first 10 words, that would leave the
>> calculation manageable (just) and give enough room to search.
>>
>> Then create a relation betwee n new global and this calculation. When the
>> user types a letter in this global and tabs out of the global. So when
>> you
>> type an m all related fields starting withj an m will appear in a portal.
>> This is best set up in a separate layout, containing just the global and
>> the
>> portal. With the portal-fields locked. So actualy the global is the only
>> thing the user can go to AND when you tab out it will directly go back
>> into
>> the field, because there is nowhere else to go to. A drawback is the
>> continuous tabbing since the relation to the portal will only refresh
>> after
>> the contents is committed.
>>
>> You could also create a relation that connects to all records that
>> contain
>> the values you need. Then create a portal large enough to see all the
>> values. You can create the portal in several columns so space would not
>> be a
>> prblem. The create a button on the first row of the portal that will set
>> the
>> field you want to the value the user has clicked and return to your main
>> layout. I would choose this last option in your case.
>>
>> Keep well, Ursus- Hide quoted text -
>>
>> - Show quoted text -
>
> Hi
>
> I would like to try it. If I have 96 values does that mean I will
> have one calculation for each of the 96 values in the list? Or will I
> have several calculations for each value to return every possibility?
>
> Thanks
> Jenny