I am curious as to what you think is the best way to handle a situation like this:
Projects are created within the app
Projects need to go through certain checks
Some of these checks are custom as raised by our developers: I made a separate table to store them
Some checks are standard with which every project needs to comply (we currently handle them with a checklist outside of our app)
It's really about the last category that I am wondering how to create such a thing. For every project I want to store the answer to these checklist questions.
Do I use a separate table for them with all checks in a column?
I would create a checklist table in a 1:N relationship, with your main table where you can associate that check with the project. This way you could have a much more consistent relational model.
If I have answered your question, please mark your post as Solved. If you like my response, please give it a Thumbs Up. You can accept more than one post as a solution Follow me on Linkedin, I talk about Power Platform www.linkedin.com/in/jonathan-manrique-rios
Was this reply helpful?YesNo
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.