I have a related table for tracking different water service connection activities. I've created all of the possible fields in the table that might be populated for at least one of these activities. Many of these activities have one or more fields in common across all of the activities.
I want to create groups of fields containing the relevant fields for each activity and ultimately use conditional visibility to display that group based on the work activity selected. However, I cannot seem to find a way to "duplicate" a field in the table into multiple groups.
To use a generic example, I have a field called 'Notes' to capture any miscellaneous info the user might need to add. This field needs to be a part of the field list for every work activity (so, every group created). Is there a way to include the 'Notes' field in every group (or in the case of other fields, some but not all groups)?
I would hate to resort to creating individual fields (NotesForActivity1, NotesForActivity2, etc.). How have others handled this situation? I'm sure I am not the first with this requirement.