This content has been marked as final. Show 2 replies
Given that you can import a .csv file and match the fields in the file to fields in your filemaker table, this is quite easy to set up during field mapping when you import the data. (You can use an auto-enter calculation to change the text to "Y".) However, You might consider restructuring your tables so that you use a table of of related "camp" records instead of dedicated fields for each camp. The resulting change make possible a lot more flexible reporting and you can add/remove camp offerings from your database by simply add/removing/changing records instead of re-defining dedicated fields.
I was able to figure it out after posting, was about to come back here and update the thread.