Jump to content
MikeREvans

Drop down list blues!

Recommended Posts

Hi there,

Please can you advise? I have a database with the fields "Category" and "Item". There are multiple categories. Each Item record is different, but some will have the same category next to them. I have a drop down list that lets me choose a category, but i would like to be able to choose in a second drop down an item that belongs in the category chosen in the first drop down.

Does this make sense?

Hope someone can help!

Thanks,

Mike

Share this post


Link to post
Share on other sites

Brilliant, thank you very much for the link. Worked a dream. However I have another query. I have added the field ItemRef, and now i need that to display the associated value, based on what is chosen in the Item drop down box.

Hope it makes sense.

Thanks,

Mike

Share this post


Link to post
Share on other sites
10 minutes ago, MikeREvans said:

Hope it makes sense.

 I am afraid not.

Share this post


Link to post
Share on other sites

Please see attached examples. I attach sample of the table, and a sample of the layout. In the layout the "Category" chosen does now create a relevant value list for the "Item" field. If you notice below the "Item" box is a "ItemRef" box, I would like that to show the "ItemRef" for the item, "ItemRef" is also a unique number.

 

Mike

TableExample.JPG

LayoutExample.JPG

Share this post


Link to post
Share on other sites

Or make ItemRef lookup the value from the subtable as an auto enter option, or simply show the now related firld from the subtable - Category::ItemRef

  • Like 1

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

  • Similar Content

    • By MutantST
      Hi All,
      Does anyone know why my scripts drop down menu might be greyed out? I am unable access these functions.
      Cheers, Simon
    • By Buckie
      Hi everyone.
      Could be something already solved years ago, but I only noticed it happening in version 14 and not in version 13 or older.
      Sometimes at random for no apparent reason the server would drop the connection to clients and this connection can almost immediately be re-established. Not a huge problem except it's annoying. I tracked it down to Time Machine interfering with the main live Databases folder. Excluding that particular folder from backups in Time Machine preferences solved the problem.
      Thought I'd let everyone know just in case.
      PS. Don't tell me that TM is bad and stuff. It's an implementation issue ("a bug", if you're feeling kind today), not an issue of TM as a general idea.
    • By chuckcou
      This should be easier, but I am having a small issue on how to limit records in Drop Down.  Currently, I can not get File Maker from showing all my records within the Drop Down.  Even when File Maker has a limited found set.
      See attached fmp12 file Help.
      Here are my records:

      If I click on my Pending script it creates a found set of just pending:

      But if you click on my DropDown you get all the records.  I just want the pending records.

       
      How can I limit the Drop Down to represent only those records that I have in my found set?
       
      Thanks in advance, Chuck
       
      Help.fmp12
    • By mwieting
      I am new to FMP so this maybe a pretty elementary question for some of you. What I want to do is have a dropdown list that is defined by certain options that I have pre-defined.  In my example these would be Serial key, Credentials, keygen, or patch.  If serial key is selected i want a text entry field to appear below or next to this dropdown list.  if credentials is selected, I want to have a username and password text enter field to appear.  If keygen or patch is selected i want to have a hyperlink entry field show up.
       
       
    • By Nuno Neto
      Good morning,
       
      I have a table with Jobs and each job is related to a specific year.
       
      I would like to have a Drop down list in my Jobs layout that would filter all the jobs for the specfic year. I have tried to use Value lists and read the year data from a table. Both options and due to the fact that I have to select a Jobs table related field to use the Dropdown invalidates my attempts.
       
      I would like to have a dropdown list that does not store anything and it just serves as a trigger to filter data. Is this possible? If so, how?
       
      Thank you for your time in advance.
       
      Nuno Neto
×

Important Information

By using this site, you agree to our Terms of Use.