Lock a relationship when creating new records
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,...
Forum Discussion
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
)
Case(
[Your facility name],
"Facility 1", "Tulsa",
"Facility 2", "Denver",
null
)