Is it possible to create a Power App which populates two tables at the same time that have a complex one-to-many relationship. Where you're adding one record to one table but several to the other (over multiple inputs)
I think this image explains my concept best.
Here we have two tables Items and Tasks, When I create or update an item, i can add, modify or remove task entries that have an association with the items table. When an item is removed, all the relevant tasks are as well. 'Attribute' will have a hard coded value depending on the instance of the task's multi-valued text field. 'ItemName' needs to copy the Name of the item, and is used as a join key.
I am open to other models that may achieve the same effect, as long as i can run reports on the views above. My understanding is that there is no actual multi-value text box, so I expect this is non-trivial. I might actually prefer a solution where filling in tasks is done with a 'pop-up' window and the blue part of the form is just a list of tasks with the appropriate filter. (Since ideally I want to add a state machine to the tasks)
发布者:admin,转转请注明出处:http://www.yc00.com/questions/1743884358a4523756.html
评论列表(0条)