0

How do I get dynamic Choice field towork?

I’m trying to create a database that mimics one originally created in Access and subsequently migrated to FileMaker. I’m getting a bit desperate, as I’m now in the last five days of my trial. If I don’t solve my ‘big’ issue, I’ll be stuck with using my newly created Numbers spreadsheet, which works, although in a fairly klutzy fashion.

I’ve previously received advice on the forum before ( thanks to Fred and John Halls ) and am hoping that an answer (quick response; detailed; and, couched in terms that a six year old will understand ) again.

I’m currently revising my design, and am now thinking on one that ‘depends’ on Choice fields, and am trying to see if it works using a very small design.

Two tables.

M:N - ProviderCategory - two fields, Provider and Category - both Choice.

Payments -two fields of concern at the moment - Provider (Choice) and Category (dynamic Choice). Also a Link to ProviderCategory with a constraint on the Provider field.

I’ve entered the following text in the Dynamic values section of the Category field (Payments) and have told (in red, no less) that I’ve made a mistake (no surprise) and that ProviderCategory cannot be found.

ProviderCategory.Category where ProviderCategory.Provider = Payments.Provider

I’d really appreciate somebody telling me what I have to do to get this working. When I enter ‘Fred’ in the Provider field (Payments), I’d like to see ‘Burger’ and ‘Pizza’ in the Category field, as both ‘Burger’ and ‘Pizza’ are in the ProviderCategory field, and connected to ‘Fred’. I do no want to see ‘Broccoli’ as a choice, because there is no way that ‘Fred’ would ever be connected to ‘Broccoli’, certainly not in the ProviderCategory table.

32replies Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular
    • jmaci1987
    • jmaci1987
    • 1 yr ago
    • Reported - view

    The new formual worked for entering data. I now have the same problem described by Anna Wenlock - I print index numbers rather than values.

    I wanted to try Ninox because I read, probably in a Claris post, that my version of FileMaker wouldn't work on a Mac M1 Computer. I've since learned that it does work, so I'm going back to FileMaker. To bad, Ninox appears to have some interesting features.

    Like
    • jmaci1987
    • jmaci1987
    • 1 yr ago
    • Reported - view

    I'd like to thank those of you who provided me with some assistance, Fred in particular. I might like to play with Ninox in the future, perhaps after 'Ninox for Dummies' is published. I think that I have to start there.

    Like
    • Fred
    • Fred
    • 1 yr ago
    • Reported - view

    you are welcome. Good luck with FM. I just could not justify the price. 

    Like
    • jmaci1987
    • jmaci1987
    • 1 yr ago
    • Reported - view

    I aggree on the price - an aarm and two legs. I already had a version I got on a work related issue some tie ago. There are things that I don't like about it (no surprise there, I suppose) but it does work.

    Like
    • jmaci1987
    • jmaci1987
    • 1 yr ago
    • Reported - view

    Where's the spell check, although it probably wouldn't help with 'tie', instead of 'time'. 

    Does anyone know if Anna Wennlock was able to solve her 'showing ID instead of description' problem. I'd still like to know the solution.

    Like
    • jmaci1987
    • jmaci1987
    • 1 yr ago
    • Reported - view

    Sorry agian. "Anna Wenlock"

    Like
Like Follow
  • 1 yr agoLast active
  • 32Replies
  • 3054Views