
I am creating some custom screens and reports to handle the Form 1095-C requirements. One of the data tables contains various fields for each month of the calendar year and my screen will have a copy forward to the subsequent months feature for these fields. The field names for each month are similar with the only variance being the month (e.g., JanCode, FebCode, MarCode, etc.) and I would like to make the copy forward logic use a for next loop constructing a variable for the field name as opposed to just having individual code lines for setting each field. What I cannot seem to determine is if there is a way to set a variable to an SL table/field name and then set the value using that variable containing the field name. I have done similar things with form objects but not with SL tables and was curious if anyone has done something like this and would have a small code sample as to how they did it.
*This post is locked for comments
I have the same question (0)Have you tried to do that, with a sql store procedure? or have an inconvenient with this scenario?
You can execute it, populate the table and read the data again.