I’m working a lot with managing data between different databases, and want to create several databases to keep things clean as the data contained within them will be of a particular type.
For example, if a car dealer decided to create a separate database for each of the cars they own, each database will have the same fields, make, model, colour, engine and so on, but if they wanted to display all the diesel variants across all the cars they had, that would mean each database will need to be engaged to show those fuel types, and what make/model they belongs to.
Whist repeating groups are set with a singular data type in mind, how is the above achievable?