Hi there
I have a parent form with a field 'Ticket' which includes a subform. I want to force one of the fields in the subform to autogenerate based upon the 'Ticket' in the parent form and the relative position of the record in the subform. Basically when a person types in 1600 in the parent form field I want at that moment for the subform to populate 1600A, 1600B, 1600C... for all records in the subform.
I don't know if I should be using the Table.PositionOf function and do some logic to not count other tickets in the table, or if there is a more direct way to reference the position just within the subform itself - Maybe using a number to letter calculation based on an auto-generated field in the second table?
Thanks!