Results 1 to 5 of 5
  1. #1
    Join Date
    Oct 2003
    Posts
    13

    Unanswered: Please help ASAP!

    I'm amking an inventory database that's quite simple, but I can't figure out how to do the easiest thing....

    I have a Category field with 2 items in the drop down list: 001 Grocery and 002 Household. I also have another "sub" category pop up list as well beneath it. So what I want is if I select 001 Grocery in the category field, I want a list of values to be shown in the Sub category popup, like eggs, bread etc... but if I select 002 Household in the category field, I want a different set of options in the "sub" category pop up.

    I've tried researching this, and I think I have to make a relationship between the two or something - I even tried using an IF calculation, but I can't seem to master it....

    Someone please HELP!!

    Mike
    MSN: quilmrt@hotmail.com
    AIM: CanadaMike20

  2. #2
    Join Date
    Oct 2003
    Posts
    706

    Unhappy

    Certainly tough to do in Filemaker, and maybe impossible.
    ChimneySweep(R): fast, automatic
    table repair at a click of the
    mouse! http://www.sundialservices.com

  3. #3
    Join Date
    Oct 2003
    Posts
    13
    It seems like something that would be SO easy... how frustrating!

  4. #4
    Join Date
    Jan 2003
    Location
    Paris, France
    Posts
    320
    You can simply create a second database called subcategorie
    With this field

    SubCat_name

    Know in your main db create a link with this new file

    main::Category <--> subcategorie::Categorie_name

    Know in your main file you can create a value list
    using related value from your link.

    If you need I can send you a sample
    Olivier Miossec
    --
    http://www.lasso-developpeur.net/
    --

  5. #5
    Join Date
    Oct 2003
    Posts
    13
    a sample would be GREAT!
    I'm assuming that <--> means relationship (?)
    THANKS SO SO MUCH!



    Originally posted by omiossec
    You can simply create a second database called subcategorie
    With this field

    SubCat_name

    Know in your main db create a link with this new file

    main::Category <--> subcategorie::Categorie_name

    Know in your main file you can create a value list
    using related value from your link.

    If you need I can send you a sample

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •