Help writing a script
Hi, I'm new writing scripts, so my apologies if this is too basic.
I would like to add 52 new fields to table1. The name of each field should be record# 1 to 52 from field1 in table2.
After that, I would like to populate each record from field 1 to 52 with a conditional that would search fieldX and return a 1 if the name of the field is present in fieldX and 0 if it isn't. But without having to write 52 If statements.