I have a record which represents a person working on a project. I then have another record which represents a number of days they will work on a project in a given month. This is a child record to the project record.
You could therefore be in the project record and link 12 records to it indicating for each month how many days are being worked on it.
Staff find this time consuming. Ideally I would have an editable grid in the project record so people could fill in the table and it would create all of the records but an editable grid only allows editing of records, not creation.
I did think of having these months as fields in the project entity but every year I would need to add more fields and rebuild the forms.
Is there an easier way to add child records to a parent record? Some kind of custom form or table?
*This post is locked for comments