i tried a specific class thinking if i could get it to work for one i could later add in the other classes and grade status....
Reg Data is the tbl that has all the registration information.. So, go to Reg Data.. Search for a particular class.....if that class is found then go to the student detail layout and set the checkbox field (transcript) to check the box which says NT 604.....
Go to Layout [ “Reg Data” (Reg Data) ]
Enter Find Mode [ ]
Set Field [ Reg Data::Number|Name; "NT 604-Revelation" ]
Set Error Capture [ On ]
Perform Find [ ]
Go to Layout [ “Student Detail” (Students) ]
Set Field [ Students::Transcript; "NT 604" ]but this doesn't work either... any thoughts?
StudentClass Table - A join table linked to Students and Classes - a table to create reports including data from both main tables
Some databases have multiple join tables specifically to make it easy to generate reports.
Google "join talbles class student site:forums.filemaker.com"
thanks David.. I feel like the underlying data structure is correct... I understand join tables... What I'm having difficulty with is how to refer to a specific part of the value list for a checkbox field.... if you have a checkbox which uses a value list.. how do I refer to a specific value in that checkbox?
Put another way... Suppose you have a checkbox field which uses these values: red, blue, green, orange.... and elsewhere I've sold a customer two objects.. one is red, one is orange. I would like to write a script that would look at the history of all items sold and then make the red and orange checkboxes active.
I think filemaker stores the multiple values as separate line items... how do i say something like.. turn on the red and orange checkboxes but don't turn on the blue and green... how do I write a calculation to refer to that specific piece of the value list?
I'm sorry if I'm not explaining this very well.. I'm still a newbie..
I don't think a single field formatted with a check box format is the best option for you. Pulling up a found set of records listing the same data you want to show in your check box formatted field would seem a simpler more straight forward way to go. Exactly how you would implement that depends on your data model.
To use a script to select a value in a check box field without overwriting previously selected values:
Set Field [ Yourtable::YourCheckBoxField ; List ( YourTable::YourCheckBoxField ; NewValueToSelectGoesHere ) ]
To test to see if a particular value in a checkbox field has been selected:
Not IsEmpty ( FIltervalues ( YourTable::YourCheckBoxField ; ValueYouAreCheckingForHere ) )
will evaluate as true if ValueYouAreCheckingForHere has been selected in the checkbox formatted field.
Thanks Phil... After more thought you're right.. a simple portal will display the data I want... and I appreciate the script help too... The List function was what I was confused about.. It's helpful to know that this is possible even if I don't need it right now.. Thanks again.