Sometimes your client doesn’t want to use a “Search Window”. They just want to type it in the field and the relationship sets up automatically. The problem is that you have to have the name match exactly with existing records. The second problem is that you have to have a script trigger to set the ID because you don’t want to have the ID to be defined as a lookup based on the name. Solution: auto-complete based on a value list allows the user to type in the name exactly, the OnObjectSave trigger checks via relationship to make sure there is a related contact and sets the ID to define the relationship. Clients who want to keep their fingers on their keyboards really like this.
source https://www.youtube.com/watch?v=Q8eG8lhljK8
source https://fmtrainingtv.blogspot.com/2022/01/defining-relationships-using-auto.html
Hello everyone I am Helen Beals. I live in Brecksville, OH, & I am 28 years old. I am a andiron apps developer and I have been working as freelancer for 3 years. I am spending most of my time learning about new languages to enhance my skills.
Subscribe to:
Post Comments (Atom)
PostMan and APIs in FileMaker (testing APIs; getting sample code including cURL)
7762 - LiveStream - 5.18.23 - PostMan and APIs in FileMaker (testing APIs; getting sample code including cURL) - Let us introduce this usefu...
-
7359 - LiveStream - 1.28.22 - Open FileMaker Q&A - LiveStream - 1.28.22 - Open FileMaker Q&A For the People who didn’t attend the ce...
-
For this miniseries, we discuss how to build Document Management with FileMaker, learn GetContainerAttribute function, learn how to import m...
-
For these three days, Nick will be covering how to implement a FileMaker calendar without SQL or relationships. For day 1, he discusses FM P...
No comments:
Post a Comment