Design Question

[gawr26]

Hey guys,

I'm struggling implementing a design I have in mind.

It's a fairly simple App where we have three Tables: Applications, Criteria and Enablers.
The goal is to have an Application form where several Apps can be evaluated.

Let's say we want to evaluate a weather app. For this we have several Enablers e.g. a database, an api etc.
Every enabler should be evaluated towards criteria such as sustainability, power consumption etc.

Bildschirmfoto 2019-11-06 um 17.46.00.png

Now what I need to to is add each criteria next to the enabler and add a field for rating(1-10)
How can I list all entries of the criteria table next to every enabler?

Help is highly apprechiated!

Cheers

[Janusz]

Maybe you can try to use Select object in which you can refer (using mysql) to any other table or you can just place data inside.
for example:

Code: Select all

SELECT cus_name,cus_name from customers

or

Code: Select all

A|A|B|B|C|C|D|D

[admin]

gawr26,

Sorry but I don't understand the question.

Could you rephrase your question with a picture of what you want it to look like?

Steven