Lock a relationship when creating new records

  • 0
  • 1
  • Question
  • Updated 4 months ago
  • In Progress
I'm building an app for clients which could be at same facility, in different cities. But each city could have more than one facility...

I currently have Clients related to facility as one to many, and facility to city as many to one... as the city for each facility will always be the same, how to I lock that down?

Say a new client is coming into a facility... I create a new facility, but I want the city to be prepopulated based on the selection of the facility.
Photo of Ryan Stanford

Ryan Stanford

  • 512 Points 500 badge 2x thumb

Posted 4 months ago

  • 0
  • 1
Photo of ROBERT VALENTINE

ROBERT VALENTINE

  • 152 Points 100 badge 2x thumb
I can think of a couple ways to accomplish this, but if it were me I would probably just set up a Formula - Text field for the city and not even use the relationship. Something like this...

Case(
[Your facility name],
"Facility 1", "Tulsa",
"Facility 2", "Denver",
null
)