0

Limit field value based on another field

Wasn't sure how to use this. I have a table that contains data for medical payments, and a number of other tables containing data on Categories, Providers, Service, etcetra. When I enter a Category in my payments table, I'd like to restrict the Provider field to values identified, presumably in a CategoryProvider table, as being appropriate for the Category entered. Then I'd like to restrict the Service field based on the Provider entry. 

3 replies

null
    • John_Halls
    • 3 yrs ago
    • Reported - view

    Hi

     

    If your data model loks like this

     

    Model

     

    Than add a constraint in the pyaments relation to Provider like this

     

    Constraint

     

    Regards John

    • John_Halls
    • 3 yrs ago
    • Reported - view

    I failed to mention, it goes here

     

    Reference

     

    Regards John

    • jmaci1987
    • 3 yrs ago
    • Reported - view

    Thanks, will give it a try. Most of my database experience is limted to Oracle (a long time ago) an MS Access, wih some fumbling on FIlemaker Pro. Am now moving to Mac M1.

    I'll give your suggestion a go. I assume that I can designate Providers as a Choice fileld. Which option would be best?

Login to reply

Content aside

  • 3 yrs agoLast active
  • 3Replies
  • 375Views