So I'm an continuing the process of learning Filemaker and I can't quite figure out how to do the following.
I want to be able to have the user select a value for a field. Based on that choice it will populate a related table with records with values in specific fields. I know this is going to be a script and that frightens me.
An example would be:
StudentName; StudentMajor (this would be from a dropdown list)
There is a related table - recommended courses
When the StudentMajor is entered, based on the choice it will place a number of records into StudentRecommendedCourses. Some Majors will have more choices entered than others. That's my first task, to figure out how to do that.
The second one would be another field that allows you to enter a value and then it places it into the related portal record. That one is a bit more complex but that is my end goal.
Thanks in advance for any help!