Let me use an example.
I am capturing all the treatments within a hospital department - each treatment captured will have a NAME for it, TIME TAKEN, a CATEGORY and a DESCRIPTION. The user will be able to create as many rows as they like with these 4 fields appearing for each treatment, so there won’t be any fixed number of rows as each department will have more or less treatments on offer than the other.
How can I set my database up to not only capture this information for each of the treatments, but also each of the 4 fields per treatment?
I thought about using a database ‘list’ but then thought I need to push this data via an API to generate a document, will I come across limitations as I won’t be able to do any complex searches across the list or manipulation of data?