Limited fields by drop down selection

I also am doing a database where there is a form. At the top of the
form I have a drop down menu field to say what type of form it is.
There are 4 or 5 types and they all have different info. Is there a
way to have filemaker show me only the fields I need based on what I
choose from that drop down?

Matt

Re: Limited fields by drop down selection

In article
<62c109c4-e30c-4f62-8a94-09e21b89c82d@a39g2000pre.googlegroups.com>,
mattG wrote:

> I also am doing a database where there is a form. At the top of the
> form I have a drop down menu field to say what type of form it is.
> There are 4 or 5 types and they all have different info. Is there a
> way to have filemaker show me only the fields I need based on what I
> choose from that drop down?

You can "hide" fields by using different layouts and / or portals, but
it might be better to simply use separate tables for the different
forms, and then simply have a "Navigation" Layout with some buttons
(one for each form type). When clicked the button goes to the
appropriate table and creates a new record ready for the user's data
entry.



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

Re: Limited fields by drop down selection

I have a Dynamic Value List demo at http://www.VirtualVermont.com/FMP.

Selection in first list determines selection available in second list.

Matt

on 11/29/07 9:17 PM mattG said:
> I also am doing a database where there is a form. At the top of the
> form I have a drop down menu field to say what type of form it is.
> There are 4 or 5 types and they all have different info. Is there a
> way to have filemaker show me only the fields I need based on what I
> choose from that drop down?
>
> Matt

Re: Limited fields by drop down selection

My mistake. Another "Read the whole thing before responding" episode...

Harry's suggestion of navigating to a specific layout depending on the
list selection is the best way to handle it.

You could actually create a pseudo-menu using a drop down coupled with a
script triggering plugin, which would eliminate having to click a button.

Matt

on 11/30/07 6:36 AM Matt Wills said:
> I have a Dynamic Value List demo at http://www.VirtualVermont.com/FMP.
>
> Selection in first list determines selection available in second list.
>
> Matt
>
> on 11/29/07 9:17 PM mattG said:
>> I also am doing a database where there is a form. At the top of the
>> form I have a drop down menu field to say what type of form it is.
>> There are 4 or 5 types and they all have different info. Is there a
>> way to have filemaker show me only the fields I need based on what I
>> choose from that drop down?
>>
>> Matt

Re: Limited fields by drop down selection

On Nov 30, 12:55 pm, Matt Wills wrote:
> My mistake. Another "Read the whole thing before responding" episode...
>
> Harry's suggestion of navigating to a specific layout depending on the
> list selection is the best way to handle it.
>
> You could actually create a pseudo-menu using a drop down coupled with a
> script triggering plugin, which would eliminate having to click a button.
>
> Matt
>
> on 11/30/07 6:36 AM Matt Wills said:
>
> > I have a Dynamic Value List demo athttp://www.VirtualVermont.com/FMP.
>
> > Selection in first list determines selection available in second list.
>
> > Matt
>
> > on 11/29/07 9:17 PM mattG said:
> >> I also am doing a database where there is a form. At the top of the
> >> form I have a drop down menu field to say what type of form it is.
> >> There are 4 or 5 types and they all have different info. Is there a
> >> way to have filemaker show me only the fields I need based on what I
> >> choose from that drop down?
>
> >> Matt

If you're looking for a script-triggering plugin, look no further than
EventScript (http://www.softs4humans.com/FMPro_Plugins.html).

Using plugins is not ideal, but there are times when it is necessary,
and this would seem a valid scenario to justify using one. I've used
EventSscript many times, and can report that it's very good.

Regards,
Dan

Dan Stuchbury
FileMaker Extraordinaire
stuchburyassociatescom

Re: Limited fields by drop down selection

"mattG" wrote in message
news:62c109c4-e30c-4f62-8a94-09e21b89c82d@a39g2000pre.google groups.com...
>I also am doing a database where there is a form. At the top of the
> form I have a drop down menu field to say what type of form it is.
> There are 4 or 5 types and they all have different info. Is there a
> way to have filemaker show me only the fields I need based on what I
> choose from that drop down?
>
> Matt

If you are using FMP 8.0 or later check out Tab Panels. If suitable to your
GUI needs, I think this is the simplest fix.