Lock a relationship when creating new records

  • 0
  • 1
  • Question
  • Updated 10 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

  • 1,146 Points 1k badge 2x thumb

Posted 10 months ago

  • 0
  • 1
Photo of ROBERT VALENTINE

ROBERT VALENTINE

  • 202 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
)