You are reading a single comment by @Chalfie and its replies.
Click here to read the full conversation.
-
In my limited experience I think of Powerquery etc as being good for extracting from stored data, but in this case there also needs to be a reasonably convenient way to populate data, including specifying the one-to-many relationships between entities from either end, which probably means a way of 'pick by names in a combo box, and store by ID'.
chez_jay
@Chalfie
Separate tables, power bi / powerquery/power pivot?
Table for each entity type.