2 tables copy values

[Pescador]

Let me try and explain what I am trying to do.

I work with youth. I have multiple tables and the youth are working on various things like sports and reading. I am trying to keep track of different requirements that are set for sports and reading. If they complete all of the requirements they are rewarded. Now for example if one of the youth reads a book about sports then it can satisfy two requirements. One under sports and one under reading. I want to create a script so that when any of the counselors clicks on a button it will check to see if one of the fields, in either sports or reading, has a date entered. If it does then it will automatically enter the same date in the other field, either sports or reading.

I hope this makes sense. I have tried a few things but nothing seems to work. Your help is greatly appreciated.

[Digital Life]

I would add a table called "Requirments" or "Activities". In it enter the things the youth can do like an activity or a book title. In the "Activities" table, for each activity create fields indicating which other tables are satisfied when this activity is completed. Then when you pull that activity into the table of things a person has done these other fields will be connected or related. So when you run your script to say that a certain person has accomplished a certain activity, the script can see what other tables need to be marked as being satisfied.

So if "Rock Climbing" has "Sports" marked "Yes" but Reading marked "No" then it will only mark the "Sports" requirement as being fullfilled. But if reading a book has both "Sports" and "Reading" flagged "Yes" then both those requirements can be marked fullfilled when the script is run.